title: get all children of a parent mysql one query for 5.6
body: <p>Table only has column</p>
  
  <pre><code>|id|Name|Parent
  </code></pre>
  
  <p>the parent being the root of the of the table</p>
  
  <p>The result required</p>
  
  <pre><code>|Parent|child_id|Ancestral_Level
  </code></pre>
  
  <p>Child_ids All the succeeding Children where the parent</p>
  
  <p>is their a way to do it on 5.6 as simple as possible?</p>
  
  <p>Update</p>
  
  <p>Now i just need the depth level to perent</p>