Laravel 如何 groupBy 之后进行Order 排序

//先group分组 
$sql = BlindBox::selectRaw('any_value(id) as id, any_value(business_id) as business_id,project_id,SUM(access_count) as access_count,SUM(join_count) as join_count,SUM(share_count) as share_count')->groupBy('project_id');

//然后from 查询排序
 $list = BlindBox::with(['project','business'])
                ->from(DB::raw("({$sql->toSql()}) as inv"))
                ->orderBy('inv.business_id');

posted @ 2022-01-11 17:16  可爱香草  阅读(50)  评论(0)    收藏  举报  来源