A
 +--B
 +  +--C
 +  +--D
 +
 A2
 +--B2
 +  +--C2
 +     +--C3
 +
 A3


##</code><code>##

id  |  parent  |  name
----------------------
 1  |       0  |     A
 2  |       1  |     B
 3  |       2  |     C
 4  |       2  |     D
 5  |       0  |    A2
 6  |       5  |    B2
 7  |       6  |    C2
 8  |       7  |    C3
 9  |       0  |    A3