How to display related data in Yii2?

Question

Yii

Tell me how to display related data in yii2? There are tables:
Posts with id, id_category, text
and Category fields with id_category, category fields.
I can query all the data from the Posts table, I do this:
$dataProvider = Posts::find()->all();
I can also make a selection in pure SQL, but I can’t find an example somewhere on how to do this with Yii2 operators.

Answer 1

In models relations are specified? If yes then you can
Posts::find()->with('category')->all();