mysql> select * from table1;

+----------+------------+-----+---------------------+

| name_new | transactor | pid | order_date          |

+----------+------------+-----+---------------------+

| 1hahha   | 1xiaohong  |    | -- :: |

| 2hahha   | 2xiaohong  |    | -- :: |

| 3hahha   | 3xiaohong  |    | -- :: |

| 4hahha   | 4xiaohong  |    | -- :: |

| 3hahha   | bob        |    | -- :: |

| 3hahha   | lee        |    | -- :: |

| 3hahha   | lee        |    | -- :: |

| 3hahha   | lee        |    | -- :: |

| 3hahha   | bob        |    | -- :: |

| 3hahha   | bob        |   | -- :: |

+----------+------------+-----+---------------------+

 rows in set (0.00 sec)

mysql> select transactor,count(*) as num from table1 where pid >= group by transactor with rollup;

+------------+-----+

| transactor | num |

+------------+-----+

| 4xiaohong  |    |

| bob        |    |

| lee        |    |

| NULL       |    |

+------------+-----+

 rows in set (0.00 sec)

mysql> select transactor,count(*) as num from table1 where pid >= group by transactor with rollup having num>=;

+------------+-----+

| transactor | num |

+------------+-----+

| bob        |    |

| lee        |    |

| NULL       |    |

+------------+-----+

 rows in set (0.00 sec)