我如何爆炸group_concat并单独显示

Question

Hi I have used group_concat to Merge the following table records of the same column, But how can i explode and display individually as an array.

Thank you

//Table A

  Customer ID     Customer_Bill_Name.......                  
    XXX001           XXX Company Name......           
    XXX002           YYY Company Name......         

//Table B

 Customer ID          Item ID 1           
     XXX001            WH15 02
     XXX001            600278        
     XX0002            600000  

This join all values to one column.

select a.*, group_concat(b.ItemId) joined
from tableA a inner join tableB b on a.customerId = b.customerId
group by a.customerId, a.customer, a.company

Result:

CUSTOMERID  CUSTOMER    COMPANY         JOINED
XXX001      XXX         Company Name    600278,WH15 02
XXX002      YYY         Company Name    600000

//Finally Table C: I want to end up like this

  Customer ID     Customer_Bill_Name       Item ID 1            Item ID 2           
    XXX001         XXX Company Name         WH15 02             600278 
    XX0002         YYY Company Name         600000