比如id为 1,3,5,44,66,32,21,6 那么返回的结果顺序也是这个顺序
$sql = "select * from ".$this->tableName()." where id in ($ids) order by field(id, ".$ids.") ";
亲测实例如下所示:
SELECT DISTINCT allot_id,customer_level from cm_customer_level_source WHERE allot_id in(1220187,1220232,1220208,1220260,1220239,1220170,1220395,1220255,1220404,1220401,1220294,1220402,1220236)
order by field(allot_id,1220187,1220232,1220208,1220260,1220239,1220170,1220395,1220255,1220404,1220401,1220294,1220402,1220236);