数据库连接查询时一对多导致数据超出左表数量

数据库连接查询时一对多导致数据超出左表数量

select * from 表1,表2 where 表1.关联字段=表2.关联字段 and 表2.主键 in(select min(主键) from 表2 group by 关联)  

实际操作四季项目时

SELECT
		u.`name`,
		u.phone,
		p.biz,
		y.district,
		count( z.user_id ) AS num
	FROM
		zh_gh_activity_ql_copy2 z,
		zh_gh_user u,
		zh_gh_activity_ql_user p,
		zh_gh_activity_ql_shop_copy2 y
	WHERE
		z.user_id = u.id
		AND u.phone = p.phone
		AND y.id = z.shop_id
		AND p.id IN ( SELECT min( id ) FROM zh_gh_activity_ql_user GROUP BY phone )
		AND z.is_get = '1'
	GROUP BY
		z.user_id
	ORDER BY
		num DESC