self::where(function ($query) use ($param) {
if (isset($param['true_name'])) {
$query->hasWhere('userIdCard', function ($query) use ($param) {
$query->where('true_name', 'like', '%' . $param['true_name'] . '%');
});
}
})
->fetchSql()
->select();生成的sql语句是 SELECT * FROM `bi_user_account` WHERE ( `UserIdCardModel`.`true_name` LIKE '%张三%' ) ORDER BY `id` DESC LIMIT 0,10,可以看到haswhere没起效果 最佳答案