How to get nested Yii2 data?

Question

Yii

There is a structure


How to get the data from the post immediately with the record user and c its position?
Here's what happened so far

public function getUser()
    {
        return  $this->hasOne(User::className(), ['id' => 'userId']);

    }

"data": [
        {
            "id": 161,
            "userId": 2,
            "text": 'Test'
            "user": {
                id:2,
                name: 'Ivan',
                positionId: 7
            }
        }
        ]

Answer 1

The answer is not the one you need, but there is reason to think. If you know how to work with Query Builder from Yii, and also know how to use Join, and understand SQL queries, then use at least bare SQL queries or using QB from Yii. Why? Because the data comes out to you in the form of associative arrays, and you either already drive such an array into your DTO, or work like with a regular array, or reformat this array into json. If you get data by links, then you will have a big performance problem and the code will become bad from this. This is more about when you need data to display a list (index). If you need data in (view), then you can try working on links or widgets there.

Answer 2

You have a relationship with User in the Post model. Does User have a connection with Position?
Add to the User model, something like:

public function getPosition()
    {
        return  $this->hasOne(Position::className(), ['id' => 'positionId']);

    }