How to link a table with tasks and users?

Question

MySQL

Hello.
There is a table with a list of users and a list of tasks for them. Each task has a director and several performers and observers, which can be any of the users. How to link these tables and get tasks for which, for example, a certain user is an observer?

Answer 1

Through an additional link table, which will contain id, user_id, task_id, role