一个表连续 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`