SELECT id, GROUP_CONCAT(mobile_phone) ‘msg’ FROM user GROUP BY mobile_phone 通过上述语句,发现GROUP_CONCAT只有配合GROUP BY的时候才会生效