select ProBrand as BrandName,(select id from Crop_Brand where Crop_Brand.BrandName=Product.ProBrand limit 0,1) as ID from Product where Parent=1 and Child=11 group by ProBrand