mysql sql找出一个表中多个字段重复的值

SELECT 
  s.periodsno,s.sitename,t.*
FROM 
  subcampaign_doctor t LEFT JOIN `subcampaign` s ON s.id=t.subCampaignId
WHERE
  (SELECT COUNT(1) FROM subcampaign_doctor WHERE subCampaignId=t.subCampaignId AND phone=t.phone)>1