I want to load/insert Route Control Profiles for Reporting Structure in Route Control Profile table

We have a custom Tree and we would like to load route control profiles by SQL insert statment like following:

I need a query to select as following to insert to route control profile table. Following is my example.

( Level1)101------------------level2  (NODE)                                                             
                                        1010--------------------------Level3(NODE)

                                                                               00000001  ---------Level4(NODE)

                                                                               00000002-----------Level4(NODE)

                                                                               00000003---------- Level4(NODE)

                                                                               

  Example: If we are loading Route Control Profile for Reporting Structure 101 Route Control profile should include all Children of 101.

I have written like this to bring the tree hierarchy:

SELECT PSTREENODE.SETID,  

  PSTREENODE.TREE_NAME,  

  PSTREENODE.EFFDT,  

  PARENT_NODE_NAME AS PARENTNODE,  

  TREE_NODE        AS NODENAME,  

  TREE_NODE        AS TREENODE,