SELECT t1.name AS level1
       t2.name AS level2
       t3.name AS level3
       t4.name AS level4
FROM       'parentmodell' AS t1
LEFT JOIN  'parentmodell' AS t2 ON t2.parentID = t1.kindID
LEFT JOIN  'parentmodell' AS t3 ON t3.parentID = t2.kindID
LEFT JOIN  'parentmodell' AS t4 ON t4.parentID = t3.kindID
WHERE t1.name = 'Magazin';