How to remake sql query correctly?

Question

Yii

Help me remake the sql query correctly for Yii I am
currently using the following query in the controllere:

$query = "SELECT * FROM products_related JOIN products ON products.id = products_related.related_id WHERE products_related.product_id = 2";

I'm trying to change it to a query like this:

//$relatedss = RelatedAssignment::find()
        ->select('*')
        ->leftJoin('products', '`products.id` = `products_related`.`related_id`')
        ->where(['products_related.product_id' => 1])
        ->all();

Tell me where am I making a mistake?

Answer 1

First set up links https://github.com/yiisoft/yii2/blob/master/docs/g... (hasOne, hasMany).
Then your request will look like this:

RelatedAssignment::find()->andWhere(['products_related.product_id' => 1])
->with(['products']) // опционально, читайте про жадную загрузку        
->all();