MySQL 同一个表 left join 三次

 

一个表连续 LEFT JOIN 三次

SELECT
  `PNode`.`id`,
  `PNode`.`name`,
  `PNode`.`title`,
  `PNode`.`pid`,
  `SubNode`.`id`,
  `SubNode`.`name`,
  `SubNode`.`title`,
  `SubNode`.`pid`,
  `ThdNode`.`id`,
  `ThdNode`.`name`,
  `ThdNode`.`title`,
  `ThdNode`.`pid`
FROM
  `hd_node` AS `PNode`
  LEFT JOIN `hd_node` AS `SubNode` ON `PNode`.`id` = `SubNode`.`pid`
  LEFT JOIN `hd_node` AS `ThdNode` ON `SubNode`.`id` = `ThdNode`.`pid`
WHERE
  `PNode`.`pid` = 0
ORDER BY
  `PNode`.`pid`