Is it worth using a pivot table in databases?

Question

Database design

Good day! Tell me, is it correct and not loadable to use a pivot table in databases?

Answer 1

the answer to the question is yes, otherwise manytomany will not work for a shop_user
comment
without a role_shop_id, because
suddenly the roles may turn out to be slightly
better than roles perms user_role and role_perm