(Yii2) How to display data from three related tables?

Question

Yii

There are 3 tables:
Service (user services) User
( user data)
UserOrg (organization in which the user works) and
related

models name , UserOrg: name

Answer 1

In Service

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

In User:

public function getUserOrg()
    {
        return $this->hasOne(UserOrg::className(),['org'=>'id']);
    }

Conclusion:

$service = Service::findOne($id);
// можно так, меньше запросов к бд: 
// $service = Service::find()->with(['User','UserOrg'])->where(['id'=>$id])->one();
echo $service->user->username;
echo $servise->user->userOrg->name;

Everything is here: www.yiiframework.com/doc-2.0/guide-db-active-recor...