我有两张 table 想加入……即营地和城市。 我已经为此用 PHP 编写了查询...但我想要 Yii2 格式的相同查询...请告诉我如何在 yii2 中编写此查询...？？

这是我的查询:

SELECT DISTINCT camps.city_id, camps.state_id, cities.city_name 
    from camps 
    LEFT JOIN cities
    ON cities.state_id = camps.state_id
    WHERE camps.state_id = 5
    AND camps.status = '1'
    ORDER BY cities.city_name ASC

最佳答案

use yii\db\Query;

$query  = new Query(); 
$query->select
                       (['camps.city_id AS City, camps.state_id AS State, cities.city_name AS Name'
                       ]) 
                      ->from('camps')
                      ->join('LEFT JOIN',' cities','cities.state_id = camps.state_id')
                      ->where('camps.state_id=:id',['id'=>5])
                      ->andWhere('camps.status=:no',['no'=>1]);


 $command   = $query->createCommand();
 $result    = $command->queryAll(); 

关于mysql - Yii2 : How to write Mysql query to select records from two tables using left join，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/29673112/