SELECT t1.name As lev1, 
       t2.name AS lev2, 
       t3.name AS lev3, 
       t4.name AS lev4
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'