title: How to delete cascade when parentID and childID are on the same table?
body: <p>I a mysql table named members that basically has two columns: <code>parentID</code> and <code>childID</code>. That way I can create a hierarchical tree based on these two columns, so for example:</p>
  
  <pre><code>parentID, ChildID
  1,2
  2,3
  3,4
  </code></pre>
  
  <p>Will generate a tree in my application with <code>parentID = 1</code> as the root and 2 as the first node, 3 as the second node, 4 as the third node and so forth.</p>
  
  <p>If I want to delete all nodes from a given <code>parentID</code> in this case, how can I accomplish this?</p>