select f.film_id,f.title 
from film as f 
left join film_category as fc on
f.film_id = fc.film_id
left join category as c on
c.category_id = fc.category_id
where
c.category_id is null;

哈哈哈哈，好蠢的代码