Builder query question From table AS table01, table AS table02

Just code the where clause directly, like so:

Code:

$builder->where('node.LFT BETWEEN parent.LFT AND parent.RGT');

There's no variable interpolation or substitution so it should be fine.