mysql - 在 yii2 中编写连接查询

Question

我想以 yii2 格式编写一个连接查询。我们在 joinWith 函数中编写的查询将表与主表连接，而不是与连接中提到的内表连接

select table1.id,table1.name
from
table1
inner join
table2
on
table1.id=table2.id
inner join
table3
on
table2.id=table3.id

Answer 1

这里示例简单的方法将在数组中生成

$list= Yii::app()->db->createCommand('select table1.id,table1.name
                                    from table1
                                        inner join table2
                                        on table1.id=table2.id
                                        inner join table3 
                                        on table2.id=table3.id')->queryAll();

$rs=array();
foreach($list as $item){
    //process each item here
    $rs[]=$item['id'];

}
return $rs;

yii 格式

JOIN_TYPE = INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN etc
$query = new Query;
$query  ->select(['SELECT COLUMNS'])  
        ->from('TABLE_NAME_1')
        ->join( 'JOIN_TYPE', 
                'TABLE_NAME_2',
                'TABLE_NAME_2.COLUMN =TABLE_NAME_1.COLUMN'
            ); 
$command = $query->createCommand();
$data = $command->queryAll();