insert into table2 select id,regexp_split_to_table(username,',') from table1;