+----+-------+------+
| id | first | last |
+----+-------+------+
|  1 | John  | Doe  |
|  2 | Jane  | Doe  |
+----+-------+------+

+----+----------+
| id |   name   |
+----+----------+
|  1 | admin    |
|  2 | accounts |
|  3 | sales    |
+----+----------+

+--------+--------+
| userid | roleid |
+--------+--------+
|      1 |      1 |
|      1 |      2 |
|      1 |      3 |
|      2 |      2 |
|      2 |      3 |
+--------+--------+

DELETE FROM UserRole WHERE id = 1;
INSERT INTO UserRole(userid, roleid) VALUES(1, 2), (1, 3);