select count(*) as num_votes,comment_id from mipeasodetabla GROUP BY comment_id;
+-----------+------------+
| num_votes | comment_id |
+-----------+------------+
|         3 |      65569 |
|         2 |      65595 |
|         2 |      65601 |
|         1 |      65612 |
+-----------+------------+

Y ahora lo que necesitaria es:
+-----------+------------+
| num_votes | count(*)   |
+-----------+------------+
|         3 |      1     |
|         2 |      2     |
|         1 |      2     |
+-----------+------------+