How to use 'N' number of for loop concept in SQL Server.

Question

 Hi,

 

Please, anyone, help me. 

parent id has child id.child ID has some child id.That some Child id has some child and so on.How to use in SQL server.

Thanks in Advance.