select t2.name,t2.flowersPic,t2.flowersId,t2.intro,group_concat(t1.price) as price
from b2017_mt_flowers t2 left join b2017_mt_format t1 on t1.flowersId = t2.flowersId where
t2.flag = 1 and t2.isDel = 0 and t1.isDel = 0 group by t2.flowersId
select t2.name,t2.flowersPic,t2.flowersId,t2.intro,group_concat(t1.price) as price
from b2017_mt_flowers t2 left join b2017_mt_format t1 on t1.flowersId = t2.flowersId where
t2.flag = 1 and t2.isDel = 0 and t1.isDel = 0 group by t2.flowersId