MySQL 5.5

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

select version();


version()


5.5.62


create table event as 
select "event_1" title, "some_desc" description, "some_date" event_date,
       1 event_id, "1.jpeg" image, "Delhi" place union all
select "event_2", "some_desc", "some_date", 2, "2.jpeg", "Delhi" union all
select "event_3", "some_desc", "some_date", 3, "3.jpeg", "Delhi";
create table donation as 
select 1 id, 789 amount, 1 event_id union all
select 2, 145, 2 union all
select 3, 456, 1 union all
select 4, 150, 2 union all
select 5, 150, 2;
SELECT e.event_id,e.title,e.description,e.event_date,e.image, 
       /*1*/
       sum(ifnull(d.amount,0)) as total,
       count(d.event_id) as total_donors 
FROM event e 
/*2*/
LEFT JOIN donation d 
/*3*/
ON d.event_id = e.event_id 
group by e.event_id;


event_id
title
description
event_date
image
total
total_donors


1
event_1
some_desc
some_date
1.jpeg
1245
2

2
event_2
some_desc
some_date
2.jpeg
445
3

3
event_3
some_desc
some_date
3.jpeg
0
0

event_id	title	description	event_date	image	total	total_donors
1	event_1	some_desc	some_date	1.jpeg	1245	2
2	event_2	some_desc	some_date	2.jpeg	445	3
3	event_3	some_desc	some_date	3.jpeg	0	0