How to multi-match two tables efficiently?
3-table scheme is the most compatible. 3rd table will look like:

CREATE TABLE jointable
(
    obj_id, 
    cat_id, 

    PK (obj_id, cat_id), 
    FK (obj_id) REF obj (id), 
    FK (cat_id) REFcat (id)
);