SQL запрос в Yii2?

Question

[Doston]

SELECT node.id, node.name, node.level
FROM ns_tree AS node, ns_tree AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt AND parent.id = 2
ORDER BY node.lft;

Такой SQL в Yii2 как будеть?

Answer 1

[Сергей Анисимов]

Вот так будеть

$rows = Yii::$app->db->createCommand('
SELECT node.id, node.name, node.level
FROM ns_tree AS node, ns_tree AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt AND parent.id = 2
ORDER BY node.lft
')->queryAll();