从数据库中优化采样

public function actionIndex()
{
    $cities = Cities::find()->where(['id' => Yii::$app->request->get('city_id')])->with([
        'districts' => function ($query){
            $query->filterWhere([
                'id' => Yii::$app->request->get('district_id'),
            ]);
        },
        'districts.complexes' => function ($query) {
            $query->filterWhere([
                'id' => Yii::$app->request->get('complex_id'),
                'type_id' => Yii::$app->request->get('complex_type_id'),
                'developer_id' => Yii::$app->request->get('developer_id'),
            ]);
        },
        'districts.complexes.apartments' => function ($query) {
            $query->filterWhere([
                'amount_room' => Yii::$app->request->get('amount_room'),
                'yardage' => Yii::$app->request->get('yardage'),
                'level' => Yii::$app->request->get('level'),
                'price' => Yii::$app->request->get('price'),
            ]);
        },
    ])->all();
    $query = [];
    foreach ($cities as $city) {
        foreach ($city->districts as $district) {
            foreach ($district->complexes as $complex) {
                foreach ($complex->apartments as $apartment) {
                    $query[] = $apartment;
                }
            }
        }
    }
    return new ArrayDataProvider([
        'allModels' => $query,
    ]);
}

但它看起来有点歪,也许我走错了路,我能做得更好吗?

UPD :我几乎喜欢亚辛·帕特尔。

$cities = Cities::find()
        //->select('cities.id') //  list your attributes comma saperated
        ->leftJoin('districts','cities.id=districts.city_id') // join districts table
        ->leftJoin('complex','districts.id=complex.district_id') // join complex table
        ->leftJoin('apartment','complex.id=apartment.complex_id') // join apartment table
        ->where(['cities.id' => Yii::$app->request->get('city_id')])
        ->andWhere(['cities.id' => Yii::$app->request->get('city_id')])
        ->filterWhere(['districts.id' => Yii::$app->request->get('district_id')])
        ->filterWhere(['complex.id' => Yii::$app->request->get('complex_id')])
        ->filterWhere(['complex.type_id' => Yii::$app->request->get('complex_type_id')])
        ->filterWhere(['complex.developer_id' => Yii::$app->request->get('developer_id')])
        ->filterWhere(['apartment.amount_room' => Yii::$app->request->get('amount_room')])
        ->filterWhere(['apartment.yardage' => Yii::$app->request->get('yardage')])
        ->filterWhere(['apartment.level' => Yii::$app->request->get('level')])
        ->filterWhere(['apartment.price' => Yii::$app->request->get('price')]);

    return new ActiveDataProvider([
        'query' => $cities,
    ]);

返回:

[
   {
      "name":"City1",
      "region":{
         "id":7,
         "name":"Region city1."
      }
   }
]