select t.* from t_test t order by field(t.name,'集团正职','集团副职','公司正职','公司副职')
多字段自定义
SELECT douyin_id,nickname,update_time,type FROM douyin_users WHERE type in (1,2,3,4,5,6,7,8,11) and fans_count>5000 ORDER BY FIELD(type,11,5,1,2,3,6,8,4,7),fans_count DESC;