我有5場名稱first_name，last_name，middle_name，status和barangay_name，我想搜索根據(jù)用戶想要的數(shù)據(jù)。問題只有最后一個字段名稱barangay_name是正常工作。其余的不是，我的查詢出了什么問題？我只檢索活躍的受益人，并且內(nèi)部加入tbl_beneficiary和tbl_barangay。  public function searchActiveBeneficiary($keyword) {        $sql = "SELECT tbl_beneficiary.beneficiary_id,         tbl_beneficiary.first_name, tbl_beneficiary.last_name,         tbl_beneficiary.middle_name, tbl_beneficiary.is_active,         tbl_barangay.barangay_name FROM tbl_beneficiary INNER JOIN tbl_barangay         ON tbl_barangay.barangay_id = tbl_beneficiary.barangay_id WHERE         tbl_beneficiary.is_active = 'Yes' AND tbl_beneficiary.first_name OR         tbl_beneficiary.is_active = 'Yes' AND tbl_beneficiary.last_name OR         tbl_beneficiary.is_active = 'Yes' AND tbl_beneficiary.middle_name OR         tbl_beneficiary.is_active = 'Yes' AND tbl_barangay.barangay_name LIKE         :keyword";        $stmt = $this->connection->prepare($sql);        $stmt->execute([            ":keyword" => '%' . $keyword . '%'        ]);        return $stmt->fetchAll();    }  //vue.js method  searchActiveBeneficiary : function() {        axios({            method : "GET",            url : this.urlRoot + "beneficiary/search_active_beneficiary.php?keyword=",            params : {                keyword : this.search_active_beneficiary            }        }).then(function (response){            vm.active_beneficiaries = response.data;            console.log(response);        });    },  <?php    include '../../private/initialize.php';    $beneficiary = new Beneficiary();    echo json_encode($beneficiary->searchActiveBeneficiary($_GET['keyword']));  ?>