CI4 Models and Table Joins

I'm using a cross reference table to have a many to many relationship in a database.  With the CI4 model, the table name and table columns are specified.  Is there a CI-standard way to combine three tables?

i.e. a better way of doing this?
select * from products JOIN xref_prod_cat ON products.id = xref_prod_cat.product JOIN categories ON xref_prod_cat.category = categories.id WHERE categories.name = "some search term"