I'm implementing some search functionality for a database of companies and their subsidiaries. For each company there may be multiple subsidiaries or none. Each subsidiary has a company_id column that links it to the id column of the parent company table.I'm implementing some search functionality for