MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t1
(
id int, email varchar(100),website varchar(100)
)

insert into t1(id,email,website)
values(1,'test@gmail.com','google.com'),
(2,'test1@gmail.com','google.com'),
(3,'test2@gmail.com','yahoo.com'),
(4,'test3@gmail.com','yahoo.com')
create table t2
(
id int, grp varchar(100),userid int,created date
)
insert into t2(id,grp,userid,created)
values(1,'group1',1,'2018-06-06'),
(2,'group2',2,'2018-06-06'),
(3,'group3',3,'2018-09-09'),
(4,'group4',4,'2018-06-06')
select website,created,count(website) as cnt
from t2
join t1 on t1.id = t2.userid
group by website, created


website
created
cnt


google.com
2018-06-06
2

yahoo.com
2018-09-09
1

yahoo.com
2018-06-06
1

website	created	cnt
google.com	2018-06-06	2
yahoo.com	2018-09-09	1
yahoo.com	2018-06-06	1