Get Tree

SELECT t1.title AS lev1, t2.title AS lev2, t3.title AS lev3, t4.title AS lev4
FROM tablename AS t1
LEFT JOIN tablename AS t2 ON t2.parent = t1.id
LEFT JOIN tablename AS t3 ON t3.parent = t2.id
LEFT JOIN tablename AS t4 ON t4.parent = t3.id
WHERE t1.title = 'title name';