thinkphp MySQL GROUP By Count gets the number of bar method

For example, the following statement is used for grouping statistics

Select COUNT (*) from es_diabetes where uid=43658 GROUP by uniques

The result is obviously not what we want, why, because it's a group up group

Change to the following, first go to heavy, then group

Select count (DISTINCT uniques) from Es_diabetes where uid=43658

Group BY is a grouping and cannot be used directly for count statistics

But select is still possible.

Or you can use subqueries

Select COUNT (*) as C from (SELECT COUNT (*) from es_diabetes where UID =43658 GROUP by uniques) as S

And the result is the same.

thinkphp MySQL GROUP By Count gets the number of bar method