It may surprise you, but SQL can only handle tabular data...Your desired output depends on the how deep the tree goes - as any new level in the tree should create a new column in the output...
It is possible to create a dynamic query where for every level there is a left join to the original table, but the output will be dynamic too...
SELECT *
FROM T1
LEFT JOIN T1 AS T2 ON T2.PARENTID = T1.ID
LEFT JOIN T1 AS T3 ON T3.PARENTID = T2.ID
So what you really have to do, is revising your requirement and chosen solution for the data layout...