SELECT p1.child,p3.parent
FROM parents p1 JOIN parents p2 ON p1.parent = p2.child JOIN parents p3 ON p2.parent = p3.child;