使用order by case 对排序加权

Order::with(['order_task' => function ($query) use ($input, $admin) {
    $query->orderBy(DB::Raw('case when status=0 and handler = '.$admin['id'].' then 0 else 1 end'))->orderBy('id','desc');
}])