i need a help.given a task.

I need to read the data_source_x table via Laravel v9 Controller functions and populate data for the 4 tables below.

Table 1 users
Table 2 orders — user_id, package_id(free) for each user
Table 3 properties
Table 4 property_aminities — after insert properties (ref data_source_x.facilities)

Important steps

SELECT * data_source
INSERT to 4 tables

This is not a CRUD operation task so I don’t need to view or input forms for this development.

I need to find the related index data from other given tables like
property_purposes
property_types
packages(free)
property_aminities after inserting properties data.

MY TASK IS Find the
properties.city_id from 'cities table' by matching with (PHP or mysql) data_source_x.address.

CAN ANY ONE GIVE ME A HELP AND INSTRUCTION