select pid,count(*) from table1 group by pid;
查出每个 pid 出现的总次数，
问题出来了，
另一个表里放了pid对应的name，
现在需要通过联合查询，直接显示出 ，
每个name出现的总次数
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
1
1553
![ThinkPHP5快速开发企业站点[全程实录]](https://img.php.cn/upload/course/000/000/068/6253d918a3ce7278.png)
收藏
SELECT a.pid as pid , a.name as name, COUNT(b.pid ) as num FROM `table1` as a, `table2` as b WHERE a.pid = b.pid;