tp5查询保持in的顺序
2022-06-30 本文已影响0人
Mracale
$idArr = [8,6,101,895,1];
$exp = new Expression('field(id,'.implode(",",$idArr).')');
$list = db("user")->field('id,username,realname,thumb_img')
->where(['id' => ['in', $idArr]])-
>order($exp)->select();
return $list;
