How should I access 2 tables by JOIN in yii2?

Question

MySQL

There is a request:

SELECT `users`.`userName`,`posts`.`title`,`posts`.`text`
FROM `posts`
  JOIN `users`
    ON `users`.`id`=`posts`.`user_id`

Those. we get a table in which all user IDs are replaced by their nicknames. How to implement this using ActiveRecord?

Answer 1

Problem solved by dependencies.

Answer 2

Here is an example .

Answer 3

$posts = Posts::find()->leftJoin('users', ['users.id' => 'posts.user_id'])->all();