How to store user categories in postgres?

Question

PostgreSQL

There is a table of categories and users, you need to make a way to bind several categories to a user.
How can this be implemented, so that later you can search by user depending on the filter by category?

I can't think of a better option and there are no answers on Google.

Answer 1

Standard many-to-many relationship via link table

users
__________
id
name
...

categories
__________
id
name
...

user_categories
__________
user_id
category_id

Basically, if the categories are just text tags, you can store them in a field of the users table as JSON, for example.