I have a many to one table.
user_id, name 1, chris 2, john
user_id, item 1, apple, 1, banana, 2, orange
How could I run a query that returns something like this:
user_id, item_1, item_2, item_3 1, apple, banana, null 2, orange, null, null
Would I need to do a sub query for each
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.