How to get all product in a father_id in php mysql

Solution:

Do you mean something like

SELECT
  childbrand,name AS child_brand_name
  product.name AS product_name
FROM brand AS childbrand
INNER JOIN brand AS parentbrand ON parentbrand.id=childbrand.parent_id
INNER JOIN product_brand ON product_brand.brand_id=childbrand.id
INNER JOIN product ON product_brand.product_id=product.id
WHERE parentbrand.name='Apple';
Copy code

Solution:

If you want to get the product name specifically of Apple and Samsung which is not stored at product_brand (see that from the sample data). You could fix the query as below:

 SELECT *,
    CASE b.name WHEN 'Apple' THEN 'iOS'
    WHEN 'Samsung' THEN 'Android' ELSE '-' END  
   FROM
    brand b
Copy code

Edited 2: If you want to get all the product name based on the parent_id. Could try the below:

SELECT *,
    CASE b.name WHEN 'Apple' THEN 'iOS'
    WHEN 'Samsung' THEN 'Android' ELSE '-' END as type_of_os
FROM
    brand b 
WHERE parent_id=0
UNION
SELECT
    b.*,
    CASE b2.name WHEN 'Apple' THEN 'iOS'
    WHEN 'Samsung' THEN 'Android' ELSE '-' END as type_of_os
FROM
    brand b
INNER JOIN
    brand b2 ON b.parent_id = b2.id 
Copy code

http://sqlfiddle.com/#!2/1f573/18