select name,SUBSTRING_INDEX(SUBSTRING_INDEX(mobile,',',id),',',-1) from tb_sequence a CROSS join
(select name,CONCAT(mobile,',')mobile,(LENGTH(mobile)-length(replace(mobile,',',''))+1) size from tb_user1 )b
on a.id<=b.size;
