MySQL 8.0

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

select version();

version()

8.0.20

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

id

1

2

3

select coalesce(id,0) from (select 1 as e union select 2 union select 3 union select 4 ) t2 left join tbl on id=e

coalesce(id,0)

1

2

3

0