How to build a database query?

Question

Yii

For Yii's, the question is actually simple =)
There is a query to the database (the example was taken from the page )
which from one table, selects the values ​​\u200b\u200bof which are not in another table:

SELECT * FROM artist 
LEFT JOIN painting
ON artist.a_id = painting.a_id
WHERE painting.a_id IS NULL;

How to build this query using yii2 methods??

Answer 1

$rows = (new \yii\db\Query())
    ->select(['*'])
    ->from('artist')
    ->leftJoin('painting', 'artist.a_id = painting.a_id')
    ->where(['painting.a_id' => null])
    ->all();

something like this, not tested but it should work

Answer 2

If there are corresponding models Artist and Painting, then you can do this:

Artist::find()->leftJoin('painting', 'artist.a_id = painting.a_id')->where(['painting.a_id' => null])->all();