title: Is there a simple way to query the children of a node?
body: <p>I've been using the crap out of the <a href="http://mikehillyer.com/articles/managing-hierarchical-data-in-mysql/" rel="nofollow noreferrer">Nested Set Model</a> lately. I have enjoyed designing queries for just about every useful operation and view. One thing I'm stuck on is how to select the immediate children (and <em>only</em> the children, not further descendants!) of a node.</p>
  
  <p>To be honest, I do know of a way - but it involves unmanageable amounts of SQL. I'm sure there is a more straightforward solution.</p>