需求:将learn_num 、 initial_join_num两字段的和进行排序
参考代码:
$students = DB::table('student_study')
->whereIn('user_id', $userArr)
->where('class_id', '=', $class_id)
->selectRaw('(learn_num+initial_join_num) as total')
->orderBy('total', 'DESC')
->groupBy('user_id') //根据学生用户Id来分组
->orderby('total', 'desc')
->orderBy('created_at', 'asc')
->paginate(20);