I want to do multi db multi tenancy for a saas type shop app so that users is in main db, and users login using this table, and all shops have different db and users_table have shops db id, and all the shops regarded model uses tenant connection.
I tried using Stancl/Tenancy but its all about domains and subdomains, i want it to be done using single domain and use users_table to store tenant_id and tenant_db_name and initialize tenant from there. If its doable without using tenancy package also its fine. I am new to laravel so an example will be kindly appreciated.