How to select only required columns in YII2 when eager loading?

Question

Yii

The documentation says that you can manage a query when eager loading with an anonymous function:
When eagerly loading a relation, you can customize...
And an example is given:

$customers = Customer::find()->with([
    'country',
    'orders' => function ($query) {
        $query->andWhere(['status' => Order::STATUS_ACTIVE]);
    },
])->all();

In this example, all columns are taken from the `order` table , but I don't need them all. By analogy, I should do this:

...
'orders' => function ($query) {
    $query->addSelect(['id', 'title', 'date']);
    $query->andWhere(['status' => Order::STATUS_ACTIVE]);
},
...

But it doesn't work, nothing is returned at all, an empty array.
What's wrong?

Answer 1

see what ready request is being formed

Answer 2

Here is my request:

$data = AddressClassificator::find()
            ->select('id, iata')
            ->with(['addressClassificatorTranslates' => function($query) {
                $query->addSelect(['id', 'name', 'country', 'city']);
                $query->andWhere(['lang' => Yii::$app->language]);
            }])
            ->asArray()
            ->all();

Generated SQL
at the exit

[
    0 => [
        'id' => '1'
        'iata' => 'AAA'
        'addressClassificatorTranslates' => []
    ]
]