MySQL Json数组转字符串拼接 简洁写法

假设有如下数据
1 [“a”, “b”, “c”]
2 [“x”, “y”]
要转为以下数据
1 a,b,c
2 x,y

只需要用到json_table 即可
代码如下

with cte2 as
( select  1 as pri_key,JSON_ARRAY('a','b','c') as  b 
  union all
  select 2,json_array('x','y')
)
select pri_key,group_concat(b.c) from cte2 as a,json_table(a.b,"$[*]"
columns(c varchar(100) path '$')
) as b
group by pri_key