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'