How to query a MySQL (Yii) database?

Question

MySQL

I don’t understand something
We have 2 tables
Content (with fields `id` and `pagetitle` and `template`) and Values ​​(`contentid` and `value`)
contendid = id
We need to make a list `pagetitle`, `values1`, `values2` from two tables. After all it is possible to make one request.
Those. you need to do:
"Select all `pagetitle` where `template`=4 and by the same id select from Values ​​all values ​​that have contentid = id.content"
Accordingly, what to write in relations
(Content) return $this->hasMany( 'Values', ['id' => 'contentid'])
and (Values) return $this->hasOne('Content', ['contentid' => 'id']) , and in the query itself?

Answer 1

Are you talking about Yii2? In Yii 1.x this was handled by the with statement:
Yii 2 should also have a similar eager loading. In any case, the joinWith function is there.