This query works fine but I'm having trouble trying to figure out why it does not return anything if the user does not have any categories in the table "user\_categories"? This is the table structure:

users: user id, username, user city

categories: category id, category name

user\_categories: user id, category id

```
SELECT users.*, GROUP_CONCAT(categories.category_name) AS categories
FROM users
INNER JOIN user_categories ON users.user_id = user_categories.user_id
INNER JOIN categories ON user_categories.category_id = categories.category_id
WHERE users.user_city = 'brooklyn'
GROUP BY users.user_id
LIMIT 10

```

I just need for the new column "categories" to be empty if no rows existed for the user\_id in user\_categories...

Thanks!