MariaDB 10.4

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

select version();

version()

10.4.13-MariaDB

create table tbl (id int unsigned auto_increment primary key)
insert into tbl () values (),(),()
select * from seq_1_to_4

seq

1

2

3

4

select * from tbl

id

1

2

3

select coalesce(id,0) from seq_1_to_4 t2 left join tbl on id=seq

coalesce(id,0)

1

2

3

0