查重SQL

SELECT 
  COUNT(`id`) AS total,
  id,
  member_id,
  shop_id 
FROM
  counsellor 
WHERE expect_counseling_fee > 0 
GROUP BY member_id,
  shop_id 
HAVING total > 1