使用条件如下: a left join b a must be b's parent 转载于:https://www.cnblogs.com/timelyxyz/archive/2012/07/24/2549672.html