order by FIELD(AuditorStatus,3,0,1,2)
laravel 写法
$data = $query->orderByRaw(\DB::Raw(‘FIELD(AuditorStatus,3,0,1,2)‘))->get()->toArray();
mysql 按值排序
原文:https://www.cnblogs.com/blog-dyn/p/10209613.html