SELECT Nodes.*
  FROM Nodes
  LEFT JOIN HasAncestor
       ON Nodes.id = HasAncestor.child
 WHERE HasAncestor.ancestor = ?


Returns for args (2)
====================
 id | node_name        | parent
----+------------------+--------
 3  | Sub Child Node 1 | 2
 4  | Leaf1            | 3