联表查询

SELECT a.*,b.brand_name FROM `pd_product` AS a LEFT JOIN `pd_product_brand` AS b ON status < 3 AND a.brand_id = b.brand_id;

只要 pd_product_brand 表里的 brand_name 数据