title: How to get all child, grand child, grand grand child.. of a parent sql table?
body: <p>I'm building a classified app, so I have to build a message system to my application, I created table called Messages, where i will store the messages, who send it, to whom, and if this message a reply to a parent message, so I have came up with this schema of table messages (I know it sucks, I should have used nested lists I think) but I really have to stick with this schema.</p>
  
  <pre><code>Id (key) | subject | body | from_id (FK_User) | to_id (FK_User) | parent
  </code></pre>
  
  <p>I want to list all siblings of a messages has parent null ! </p>
  
  <p>for ex:</p>
  
  <pre><code>id | parent
  ----------- 
  1    null 
  2    1 
  3    2 
  4    3 
  </code></pre>
  
  <p>I want to show all 1,2,3 messages under the parent message !! 
  I use MySQL, and Laravel 4 eloquent as ORM !
  so, I really need help !</p>