某 SQL Builder 將使用的 FROM 建立語法

gistfile1.php

<?php

// (`model1` LEFT JOIN `model2` ON `model2`.`col2`=`model1`.`id`)
$from = $b->tables(
    $b->left_join($m1, $m2, $b->eq($m2->col2, $m1->id))
);

// `model1`,`model2`,`model3`
$from = $b->tables($m1, $m2, $m3);

//((`model2` LEFT JOIN `model3` ON `model2`.`col2`=`model3`.`id`) LEFT JOIN `model1` ON `model2`.`col2`=`model1`.`id`)
$from = $b->tables(
    $b->left_join(
        $b->left_join($m2, $m3, $b->eq($m2->col2, $m3->id)),
        $m1,
        $b->eq($m2->col2, $m1->id)
    )
);