MySQL 8.0

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

create table first_table (id int primary key, json_field json);
insert into first_table values (1, '[1,2,3]'), (2, '[2,3]'), (3, '[1,3]');

Records: 3  Duplicates: 0  Warnings: 0


create table second_table (id int primary key, name text);
insert into second_table values (1, 'bob'), (2, 'sam'), (3, 'mary');

Records: 3  Duplicates: 0  Warnings: 0


select id, json_pretty(json_field) from first_table
where json_overlaps(json_field, (select json_arrayagg(id) from second_table where name='Sam'));


id
json_pretty(json_field)


1
[
  1,
  2,
  3
]

2
[
  2,
  3
]