Yii2 子查询

$query = MemberUsePowerRecord::find()->select('max(id),id,new_battery_serial,member_id,end_time,cabinet_serial,order_status,type')->groupBy('member_id');
 $res = (new Query())->from(['r'=>$query])->where(['in','r.order_status',[1,2]])->andWhere(['r.type'=>1])->select('id,new_battery_serial,member_id,end_time,cabinet_serial')->all();