Try
UNION
:
SELECT 'CRecords' as [Type], COUNT(*) AS [Count] FROM ff_fvdcbdev.dbo.app_User cu inner join ff_fvdcbdev.dbo.app_Person cp on cu.idUser = cp.idUser
WHERE cp.emailAddress = @Email
UNION
SELECT 'MRecords' as [Type], COUNT(*) AS [Count] FROM freefunds.dbo.app_User mu inner join freefunds.dbo.app_Person mp on mu.idUser = mp.idUser
WHERE mp.emailAddress = @Email