Thaks SSChampion for reply.

I solved it using Recursive CTE. This is the solution:

WITH tree(ID, ITEM, PID, LEVEL, TreePath, FilePath)

AS(

SELECT MTID, Item, 0 AS PID, 0 AS LEVEL, CAST(MTID AS...