mysql> SELECT S.title, COUNT(*)
FROM user U, style S
WHERE U.styleid = S.styleid
GROUP BY U.styleid;
+------------+----------+
| title      | COUNT(*) |
+------------+----------+
| TFP v4.0   |    26528 |
| Dark Cloud |      373 |
| Sandstorm  |      190 |
+------------+----------+
3 rows in set (0.23 sec)