TP5 in排序

       $exp = new \think\db\Expression('field(id,'.$pay_order.')');   //where in order by field('id,...')//排序
            $query->order($exp);
 if(empty($params['date'])){
                $query->where('id','IN',function($query)  {
                    $query->table('lb_order')->where('status', 1)->field('uid');
                });
            }else{
                $date = $params['date'];
                $time = date('Y-m-d',strtotime($date));
                $query->where('id','IN',function($query) use ($time)  {
                    $query->table('lb_order')->where('status', 1)->whereBetweenTime('pay_time', $time)->field('uid');
                });
            }