MySQL 8.0

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

create table tbl_task(t_id int,      member_id int);
insert into tbl_task values(1,       1);
insert into tbl_task values(2,       1); 
insert into tbl_task values(3,       2);
insert into tbl_task values(4,       1);
create table tbl_member(id int, name varchar(100),      team_id int);
insert into tbl_member values(1,       'Ali'       ,1);
insert into tbl_member values(2,       'Khalil'    ,1);
insert into tbl_member values(3,       'Bilal'     ,1);
insert into tbl_member values(4,       'John'      ,2);
insert into tbl_member values(5,       'Smith'     ,2);
select m.*,(select count(t_id)from tbl_task t where t.member_id=m.id)  as 'Tasks' 
from tbl_member m 
where m.team_id=1


id
name
team_id
Tasks


1
Ali
1
3

2
Khalil
1
1

3
Bilal
1
0