CodeIgniter 4 Playground

Hi team, sorry, i might be posting in wrong thread as I just joined.
In CI4, I just want to know the possible way of connecting multiple databases and joining them dynamically.

Some possible structure as follow

db_main to join with db_of_companyA
db_main to join with db_of_companyB

The idea is to have separated db set for each company to connect to db_main as main dataset.
The DB credentials of each company are in a table in db_main

Thanks in advance.

Don't mind it. I found the solution. I created my own builder. Thanks.