Insert Into Select multiple columns mysql
Here is a way, using variables:

SET @count1=0;
SET @count2=0;
SELECT COUNT(email) INTO @count1 FROM user;
SELECT COUNT(email) INTO @count2 FROM application;
INSERT INTO subdata (reggeduser,completed) VALUES (@count1, @count2);