mysql 按值排序

order by FIELD(AuditorStatus,3,0,1,2)

laravel 写法

$data   = $query->orderByRaw(DB::Raw('FIELD(AuditorStatus,3,0,1,2)'))->get()->toArray();