这里是模型里的一个方法，所以直接用$this
$ids = $this->where('user_id','=',$user_id)
->group('order_id')
->field('min(id) as id')
->buildSql();
$result = $this->where('id','in',$ids)
->whereBetweenTime('create_time',$start_time,$end_time)
->order('id','desc')
->select();或者:$ids = $this->where('user_id','=',$user_id)
->group('order_id')
->field('min(id) as id')
->fetchSql(true)
->select();
$result = $this->where('id','in',$ids)
->whereBetweenTime('create_time',$start_time,$end_time)
->order('id','desc')
->select(); 最佳答案
