gli assegni un alias
SELECT COUNT (autoeval) as conto FROM user_cp_1 WHERE utente = '$user[username]' AND autoeval = 'happy'
UNION
SELECT COUNT (autoeval) as conto FROM user_cp_gen WHERE utente = '$user[username]' AND autoeval = 'happy'