CREATE VIEW `view_need_unioncheck` AS
select count(1) AS `count`,`pm`.`menu_id` AS `itemTypeId`,concat(',',group_concat(`pm`.`position_id` separator ','),',') AS `positionIds`
from `t_sys_position_menu` `pm` where
exists(select `gi`.`code` from `t_ck_group_items` `gi` where ((`gi`.`is_need_unioncheck` = 1) and (`pm`.`menu_id` = `gi`.`code`)))
select count(1) AS `count`,`pm`.`menu_id` AS `itemTypeId`,concat(',',group_concat(`pm`.`position_id` separator ','),',') AS `positionIds`
from `t_sys_position_menu` `pm` where
exists(select `gi`.`code` from `t_ck_group_items` `gi` where ((`gi`.`is_need_unioncheck` = 1) and (`pm`.`menu_id` = `gi`.`code`)))
group by `pm`.`menu_id`
如 A:1 1
A:2 2
B : 1 1
B : 2 2
B : 3 3
最终变成
A 2 ,1,2,
B 3 ,1,2,3,
注:group_concat 能将相同的行组合起来,默认以,分隔