WITH tree (id, parentid, level, name) as
(
   SELECT id, parentid, 0 as level, name
   FROM your_table
   WHERE parentid = 0

   UNION ALL

   SELECT c2.id, c2.parentid, tree.level + 1, c2.name
   FROM your_table c2
     INNER JOIN tree ON tree.id = c2.parentid
)
SELECT *
FROM tree