$query, 'pagination' => [ 'pageSize' => 5 ], 'sort' => [ 'attributes' => [ 'admin_menu_id', 'name', 'path', 'param', 'status', 'hide_min', 'parentt' => [ 'asc' => ['name' => SORT_ASC], 'desc' => ['name' => SORT_DESC], 'default' => SORT_DESC ] ] ] ]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere([ 'admin_menu_id' => $this->admin_menu_id, 'admin_menu_pid' => $this->admin_menu_pid, 'status' => $this->status, 'hide_min' => $this->hide_min, 'sort' => $this->sort ]); $query->andFilterWhere(['like', 'name', $this->name]) ->andFilterWhere(['like', 'path', $this->path]) ->andFilterWhere(['like', 'param', $this->param]) ->andFilterWhere(['in', 'admin_menu_pid', $this->find()->select(['admin_menu_id'])->andFilterWhere(['like', 'name', $this->parentt])->column()]); return $dataProvider; } }