You can add a COUNT(*) to your SQL and get the normal data AND a count.

Nonsense. If you put a COUNT(*) in your SELECT you get one line only.

If you add a COUNT(*) to normal data, then you need to put a GROUP BY clause, thus getting a count for each group, not the total.

You cannot get detailed data AND its count in one single SQL statement.