Distinct Count

COUNT(DISTINCT user.id)

Distinct Record

SELECT  
Distinct(user.id),user.*,  
FROM  
user