mysql join many to one table and display each 'many' record as an additional column
As Kondybas suggests in his comment, you can use GROUP_CONCAT to concatenate the columns

SELECT user_id, GROUP_CONCAT(item,',') as items 
FROM table_name 
GROUP BY user_id


Note that all original columns is fit into one column in the answer.