public function searchWeixinAttr($query, $value)
{
$query->has('weixin', '>', 0);
}
SQL:"SELECT * FROM `admin_user` WHERE EXISTS ( SELECT `UserBind`.`uid` FROM `weixin_user_bind` `UserBind` WHERE ( `User`.`id` =UserBind.uid ) ) AND `company_id` = 1"
问题:exist语句里面引用了User.id,而前面没有把admin_user表别名设置为User,导致User.id字段不存在 最佳答案
