Get rows that are referenced in another table
Sounds as if you are looking for something like this:

SELECT product.id
FROM product
where exists (select *
              from bom 
              where bom.parent_item_id = product.id);


Alternatively

SELECT id
FROM product
where id in (select parent_item_id
             from bom);