SELECT b.id as recordb, a.id as recorda
FROM tabella1 as c
LEFT JOIN tabella1 as b on c.parent = b.id
LEFT JOIN tabella1 as a on b.parent = a.id
WHERE c.id = 'valoreCheTiPare'


A cosa serva l'altra tabella non l'ho capito però :master: