Table Relationship cardinality
Yes, if a user can have many (e.g. up to 2) types, and each type of course has many users, then this is a many-to-many relationship.

Users &gt;--------&lt; UserTypes


Any logical many-to-many relationship needs a third physical table that references both.

Users ----&lt; UserHasType &gt;---- UserTypes


For example, this table could look like the following:

CREATE TABLE UserHasType (
  user_id INT,
  type_id INT,
  PRIMARY KEY (user_id, type_id),
  FOREIGN KEY (user_id) REFERENCES Users(user_id),
  FOREIGN KEY (type_id) REFERENCES UserTypes(type_id)
);