This is incorrect. What we were looking for was the user with the most statuses. Calling MAX() with the user_id would return the highest user_id, which isn't what we're looking for. The following would work:

SELECT users.name FROM users INNER JOIN statuses ON users.id = statuses.user_id GROUP BY statuses.user_id ORDER BY COUNT(statuses.user_id) DESC LIMIT 1;