title: organize nested mysql databse structure for Multilevel marketing system
body: <p>If someone already done nested database structure for Multilevel Marketing (MLM) system, please share your knowledge, because i am in stuck.</p>
  
  <p>I have two options: first one is old way, table structure like 
  id,
  name,
  parent_id etc,</p>
  
  <p>second options is Hierarchical Data structure in MySql something like,
  id, 
  name,
  lft,
  rgt, etc,</p>
  
  <p>Well, the main thing is both has pros and cons, please advice me. </p>
  
  <p>Lastly, about the tree structure should be like this</p>
  
  <p><a href="http://en.wikipedia.org/wiki/File:Multi-level_marketing_tree_diagram.png" rel="nofollow">http://en.wikipedia.org/wiki/File:Multi-level_marketing_tree_diagram.png</a></p>