如何使用left join on and查询 [ 新手入门 ]

顶一下顶一下顶一下

with 方法可以帮你解决。

$query = (new \yii\db\Query())
            ->select('a.id as id,title,create_time,modify_time,username,name')
            ->from('yii_article AS a')
            ->leftJoin('yii_user AS u','u.id = a.user_id')
            ->leftJoin('yii_category AS c','c.id = a.category_id')
            ->where(['c.name'=>'新闻分类'])
            ->limit(4)
            ->orderBy('id DESC')
            ->All();