Select *,(SELECT COUNT(*) From tp_users_signin WHERE userid=b.user and to_days(now()) - to_days(FROM_UNIXTIME(tp_users_signin.create_time,"%Y-%m-%d")) <= 1) as scount from tp_users b group by b.id HAVING scount >0
原生SQL语句怎么转换成 下面这样的?下面的有问题,谢谢各位了。
$list = Db::name('Users')
->alias('b')
->field('Select *,(SELECT COUNT(*) From tp_users_signin WHERE userid=b.user and to_days(now()) - to_days(FROM_UNIXTIME(tp_users_signin.create_time,"%Y-%m-%d")) <= 1) as total')
->group('b.id')
->having('total > 0')
->paginate([
'query' => Request::get(),
'list_rows' => $pageSize,
]);