我想做的是查询主表存在于另一个子表的最新一条记录,$this->yuyue是主表,$this->model是子表有主表的多条记录,查询倒是查出来了,但是我想加个搜索条件就不行了,总提示不存在y_uid这个字段,我也很是纳闷不知道怎么回事,哪位帮忙看下,谢谢了!。
```php
if (!empty(!$param['y_uid'])) {
$where['y_uid'] = $param['y_uid'];
}
if (!empty($param['searchStart'] && !empty($param['searchEnd']))) {
$where['y_sf_addtime'] = [['egt', strtotime($param['searchStart'] . "00:00:00")], ['elt', strtotime($param['searchEnd'] . "23:59:59")], 'and'];
}
$huifangs = $this->model
->order('y_sf_addtime', 'desc')
->limit(10000) //不加有可能获取的不是最新的一条
->buildSql();
$selectResult = $this->yuyue->alias('a')
->join([$huifangs => 'b'], 'b.yyid = a.id', 'LEFT')
->where($where)
->where(['b.yyid' => ['neq','null'], 'b.y_tag' => ['in','1,2,3']])
->field('a.id,a.y_name,a.y_sex,a.y_age,a.y_did,a.y_province,a.y_city,a.y_mzh,b.y_sf_addtime,b.y_sfnrbc,b.id as bid,b.y_hzsq,b.yyid,b.y_nextsfsj,b.y_uid')
->group('a.id')
->limit($offset, $limit)
->order('b.y_sf_addtime desc')
->select();
```