title: How to get all product in a father_id in php mysql
body: <pre><code>brand(id, parent_id, name)
        1 |     0    | Apple
        2 |     0    | Samsung
        3 |     1    | Iphone 3S
        4 |     1    | Iphone 4S
  product(id, name)
          1 | OS
          2 | Andriod
  product_brand(product_id, brand_id)
                    1     |    3
                    1     |    4
  </code></pre>
  
  <p>And mysql:
  How to get <code>product name</code> when <code>brand name = Apple</code></p>
  
  <pre><code>SELECT * FROM product_brand
  LEFT JOIN brand ON brand.id = product_brand.brand_id
  WHERE brand.id = 1 // Apple
  </code></pre>
  
  <p>Ex: if get Apple(id=1) is result => OS, If get Samsung(id=2) is result => Andriod</p>