Select from table where has at least one child with value

If you have the relationship configured in the table, I believe you can do this with a
->contains…

for any other relevant fields you need, including from any related tables.fields.