第一种写法:
SELECT USER_ID,USER_NAME FROM user
WHERE USER_ID in (1008622115,1008610664,1008622031,1008610318)
ORDER BY INSTR(',1008622115,1008610664,1008622031,1008610318,',CONCAT(',',USER_ID,','))
第二种写法:
SELECT USER_ID,USER_NAME FROM user
WHERE USER_ID in (1008622115,1008610664,1008622031,1008610318)
ORDER BY field(USER_ID, 1008622115,1008610664,1008622031,1008610318)