Select Code to Download

Nodes
=====
...
 1  | Parent Node1     | 0
 2  | Child Node 1     | 1
 3  | Sub Child Node 1 | 2

SELECT Nodes.*
  FROM Nodes
...
----+------------------+--------
 3  | Sub Child Node 1 | 2
 4  | Leaf1            | 3

SELECT Nodes.*
  FROM Nodes
...
 id | node_name        | parent
----+------------------+--------
 3  | Sub Child Node 1 | 2