How to use JOIN in Yii2?

Question

Yii

Hello! I'm using JOIN for the first time, so I'll do something wrong... help me solve the problem...
so I wrote this query

Category::find()->leftJoin('post', 'post.category_id = category.id')->all()

there is no error, but when outputting to print_r(), there are no posts.... or I will do something wrong
. ..
I don't want to use with()
if it's not difficult to explain in detail with an example)

Answer 1

Category::find()->joinWith('post')->all()
and add a getPost relationship to the Category model

public function getPost(){
return $this->hasMany(Post::classname(),['category_id' => 'id']);
}