原生我知道,但是用laravel的方式我写不出来,因为后面还要分页,自己写分页太麻烦了,哪位大神说说,谢谢!下列为原生的sqlselect * from (select
f.id,f.user_id,u.nickname,f.sign,f.content,f.status,f.user_ip,f.set_time
from feedback as f,users as u where f.user_id=u.id order by set_time
desc)as t group by t.user_id
1 回答
单色彩虹
TA贡献34条经验 获得超11个赞
用laravel 的子查询吧
$xxx = DB::table( DB::raw("({$model->toSql()}) as sub" )) ->mergeBindings($model->getQuery()) ->group.....
添加回答
举报
0/150
提交
取消