Option 1
SELECT username, userID, count(reports.reported) as numreports FROM
users LEFT JOIN reports ON users.username=reports.reported
WHERE activated=1
GROUP BY username, userID
Option 2:
SELECT username, userID,
(select count(*) from reports WHERE users.username=reports.reported) as numreports
FROM users
WHERE activated=1