在我的Drupal 8站點中，我有一個“搜索”頁面功能。為此，我正在嘗試將我的自定義SQL查詢與核心Drupal搜索查詢連接起來。我正在嘗試向.module文件中的SQL查詢添加參數，但它向我拋出了語法錯誤。我的查詢如下：function mymodule_views_query_alter(\Drupal\views\ViewExecutable $view, \Drupal\views\Plugin\views\query\QueryPluginBase $query) {//If my view is my-search and the Miles field is not empty and not 'Any' and zipcode field is not empty  $searched_miles_value = $view->getRequest()->get('field_miles_value');  $searched_zip_value = $view->getRequest()->get('field_zip_value');  if(!empty($searched_miles_value)) {    _remove_view_query_condition($query, 'node__field_miles.field_miles_value');  }   if(!empty($searched_zip_value)) {    _remove_view_query_condition($query, 'node__field_zip.field_zip_value');  }  if($view->id() == 'my_search'  &&       !empty($searched_miles_value) &&      !empty($searched_zip_value) &&      ($searched_miles_value != 'any')) {        $connection = \Drupal\Core\Database\Database::getConnection();        $result = $connection->query('SELECT to_zip FROM zipmaster_xref WHERE from_zip = [field_zip_value] AND miles = [field_miles_value]')->fetchAll();        $target_zips = ['98567'];//hardcoded for testing        foreach($result as $zip) {          $target_zips[] = $zip->to_zip;        }        $query->addWhere('new_group', 'node__field_zip.field_zip_value', $target_zips, 'IN');  }我在SQL查詢行上遇到語法錯誤。有什么幫助嗎？