查询主表所有符合条件的数据的同时 查出从表与之关联的数据

1.查询主表所有符合条件的数据的同时 查出从表与之关联的数据
2.将一对多的数据进行分组拼接

select t.id , t.rule_name , t.non_Member_Day , t.membership_Day ,
t.create_Time ,
ifnull(t.rule_id,t.id )rule_id,
group_concat(t.goods_name)goods_name, group_concat(t.goods_id) goods_id from
( select
rule.id,rule.rule_name,rule.membership_day,rule.non_member_day,rule.create_time,
goods.id as detail_id, goods.rule_id ,goods.goods_id, goods.goods_name

     from integral_rule rule
     left join (
             select goods.id as detail_id, goods.rule_id ,goods.goods_id, goods.goods_name ,
            rule.id,rule.rule_name,rule.membership_day,rule.non_member_day,rule.create_time
         from integral_relation_goods goods
         left join integral_rule rule
         on goods.rule_id = rule.id
         where rule_type = 1

         ) goods
     on goods.id = rule.id
     where rule_type = 1

 ) t group by t.id
order by t.create_time;