MySQL 8.0

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


@@version


8.0.21


CREATE TABLE table1 (
  `id` INTEGER
);

INSERT INTO table1
  (`id`)
VALUES
  ('1'),
  ('2'),
  ('3'),
  ('4'),
  ('5'),
  ('10'),
  ('15'),
  ('18');
  
  
  CREATE TABLE table2 (
  `id` INTEGER
);

INSERT INTO table2
  (`id`)
VALUES
  ('2'),
  ('3'),
  ('4'),
  ('20'),
  ('25'),
  ('30');
  
  
  

CREATE TABLE table3 (
  `id` INTEGER
);

INSERT INTO table3
  (`id`)
VALUES
  ('4'),
  ('5'),
  ('35'),
  ('45'),
  ('55');
  
  
  
  

CREATE TABLE table4 (
  `id` INTEGER
);

INSERT INTO table4
  (`id`)
VALUES
  ('10'),
  ('15'),
  ('75'),
  ('85');
select 'table1' as col1,count(table1.id) as tbl1,count(table2.id) as tbl2,
count(table3.id) as tbl3,count(table4.id) as tbl4 
from table1
left join table2 on table1.id=table2.id
left join table3 on table1.id=table3.id
left join table4 on table1.id=table4.id
union all
select 'table2' ,count(table1.id),count(table2.id),count(table3.id),count(table4.id) 
from table2
left join table1 on table2.id=table1.id
left join table3 on table2.id=table3.id
left join table4 on table2.id=table4.id
union all
select 'table3' ,count(table1.id),count(table2.id),count(table3.id),count(table4.id) 
from table3
left join table1 on table3.id=table1.id
left join table2 on table3.id=table2.id
left join table4 on table3.id=table4.id
union all
select 'table4' ,count(table1.id),count(table2.id),count(table3.id),count(table4.id) 
from table4
left join table1 on table4.id=table1.id
left join table2 on table4.id=table2.id
left join table3 on table4.id=table3.id


col1
tbl1
tbl2
tbl3
tbl4


table1
8
3
2
2

table2
3
6
1
0

table3
2
1
5
0

table4
2
0
0
4