SELECT comment.iduser,users.*,COUNT( * ) AS total FROM users, comment WHERE users.id = comment.iduser GROUP BY comment.iduser ORDER BY users.id