我有一個名為 city 的表，其中有 city_id 和 city_name 列。我想要的是我想從 city 表中查詢 city_id 的值到另一個名為 spinner 的表中，該表也包含 city_id 列。兩個 city_id 都具有相同的 int 數據類型。這是我的 php 代碼示例<?php$response = array();include 'DBConnect.php';//Get the input request parameters// $inputJSON = file_get_contents('php://input');// $input = json_decode($inputJSON, TRUE); //convert JSON into array//Check for Mandatory parameters $city_name = $_POST['city_name'];// $city_id = $_POST['city_id'];// $city_query = "SELECT city.city_id FROM city INNER JOIN spinner ON city.city_id = spinner.city_id";// $sql = "SELECT city_id FROM city WHERE $city_name ";// $stmt = $con->query("SELECT city_id FROM city WHERE $city_name");// $city_id = $stmt;    // $insertQuery  = "INSERT INTO spinner(city_id) VALUES (?)";    $insertQuery = "INSERT INTO spinner(city_id) SELECT city_id FROM city WHERE $city_name";    if($stmt = $con->prepare($insertQuery)){        // $stmt->bind_param('s',$city_id);        $stmt->execute();        $response["status"] = 0;        $response["message"] = "city data sent";        $stmt->close();    }    else{        $reponse["message"] = "cannot send data";    }echo json_encode($response);?>