$sql = db('agent')
->alias('a')
->join('__AGENT__ b','a.parent_id=b.id','LEFT')
->field('a.*,b.username parent')
->select(false);
echo $sql;得到的sql是这样的:
SELECT `a`.*,b.username parent FROM `ec_agent` `b` LEFT JOIN `ec_agent` `b` ON `a`.`parent_id`=`b`.`id`别名都变成b了
求解,是bug吗