select * from nodes,children 
where nodes.node_id=children.node_id
and children.parent_id=?