Stuff

mysql> SELECT * FROM users;
+------+------+
| id   | name |
+------+------+
|    1 |    0 |
+------+------+

mysql> SELECT * FROM permissions;
+--------+----------------+
| userID | permissionName |
+--------+----------------+
|      1 | perm1          |
|   NULL | perm2          |
+--------+----------------+


mysql> SELECT * FROM users RIGHT JOIN permissions ON users.id = permissions.userID WHERE users.id = 1;
+------+------+--------+----------------+
| id   | name | userID | permissionName |
+------+------+--------+----------------+
|    1 |    0 |      1 | perm1          |
+------+------+--------+----------------+