SELECT DISTINCT g.id,g.name FROM sh_goods g
LEFT JOIN sh_goods_attr_value ga ON g.id= ga.goods_id
LEFT JOIN sh_goods_attr a ON ga.attr_id= a.id
WHERE ga.attr_id IN(SELECT id FROM sh_goods_attr
WHERE parent_id = (SELECT id FROM sh_goods_attr WHERE name="基本信息")
);