laravel 先排序后分组怎么写

Question

原生我知道,但是用laravel的方式我写不出来,因为后面还要分页,自己写分页太麻烦了,哪位大神说说,谢谢!
下列为原生的sql

select * 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

Answer 1

SOQTPSHKGCSFIKHWSVKZPKCZOENJFPKNDKUVEUXADZXMAPYHQMJYTWZSUJFORMIEODOYAQTCYHWMHTWLHXZJSURVYAQGVLODGBQYZVEAQFIXNXUPSMCYOKGCYORNQFIEAQMVKERBLBDTDAUDSOKTCYOYAOLVKNJYBPSVFSBKNWFNVYAKOKZJQMJFHSVVYNDTCLODMJRMVEUDKAPSILTCSIEGCYURCEHXGVLHQTJXQSCSXTJWGWDSHKLGWYORHWYHDNILUKGWTIEBJFNJFORDNVFVKGILIKKZCWMORHDMWGPKUDMIEAIYCSOXHWMPLUKLUDSIEGPDOKYAQSIXUJMXNXTIFUQMVFADTIEOQMOLGCEZORHJZVEHENMPRHDMIYURHAQSBYADSIDTJMIRHBXGCSPDTCFUDFVYBFHQSBKUJZIKHVDGJLNQSIRURGWLBEGCMVLMHRNJFHEUWFFUQFIEADGQMTVRNQTOLOYBZCEOETJMUQTHIKHDMOEAKGHDFPLTQSVFIVRTOETWYOETPESVKZPYADAADZPRGJSVLZEAPFVXTBLVRBJTCLAWMHFOTPEHKMCXNKNNWFBRAPLVRHTIXHWFVQAQAUDDQWFJWPFBFREUAWWFSBOOHUUJFYDZMCDJBYUGQFYYVDTCILHTJSIONDJTZVUHSIFXFOXUWZADQFJLUKGUXMILOJZOKTPSOEUKTPYGCRAXGWSJFHXHIFVXNDXZVYNPZIKAXIXGQFBRNWMPTBXAWFVKGOLJYVEACMHKTWXGPZBETCYBQCKAJKGQFVFUACQTILHQMVYRZPEHDTILHCMILOKMPSORBDMVXAJZOXHBZIXHQFCENPSRTPLHKGCFHRYADGIEAWZAKACLHDGPFAKA

Answer 2

用laravel 的子查询吧$xxx = DB::table( DB::raw("({$model->toSql()}) as sub" ))     ->mergeBindings($model->getQuery())     ->group.....