Potresti fare:

SELECT COUNT(C.email) FROM contatti AS C INNER JOIN user AS U ON C.email = U.email