Model best practices question

I'm building a REST API with four endpoints (I must say that I just started with CodeIgniter). One of them is to get data, and it receives two parameters id, and code via GET.
The issue is that the data is fetched from five different tables, all related (say table1, table2, ..., table5).
Here I have a doubt about what is the right way to build the solution:
Option 1: Create a model where I get the information from a SQL that joins all tables filtering on table1 where: (table1.id = id) AND (table1.code = code) AND (table1.status <> 'REJECTED') and have the controller call this model method. For example, in the controller I would have a method that contains something similar to the following:

PHP Code:

$dataModel = new DataModel();

// Retrieve data from all the tables with one SQL and JOINS
$data = $dataModel->getData($id, $code);

$responseData = [
    'column1' => data['column1'],
    'column2' => data['column2'],
    'column3' => data['column4'],
    ...
    'columnN' => data['columN']
]; 


Option 2: Create multiple models, one per table and from the controller call the methods that return me the information of each model. For example, in the controller I would have a method that contains something similar to the following:

PHP Code:

$table1Model = new Table1Model();
$table2Model = new Table2Model();
$table3Model = new Table3Model();
$table4Model = new Table4Model();
$table5Model = new Table5Model();

// Retrieve data from table1 table
$table1Data = $table1Model->getData($id, $code);

// Retrieve data from table2 table table1.idTable2 = table2.id
$table2Data = $table2Model->getData($idTable2);

// Retrieve data from table3 table table table1.id = table3.idTable1
$table3Data = $table3Model->getData($id);

// Retrieve data from table4 table table table2.id = table4.idTable2
$table4Data = $table4Model->getData($idTable2);

// Retrieve data from table5 table table1.idTable5 = table5.id
$table5Data = $table5Model->getData($idTable5);

$responseData = [
    'column1' => table1Data['table1Column1'],
    'column2' => table2Data['table2Column2'],
    'column3' => table3Data['table3Column4'],
    ...
    'columnN' => table5Data['table5ColumN']
]; 


The same query would be for an endpoint that needs to insert or update data in multiple tables.
What would be the best option? Is there a better one that I don't realize?

Any opinion/help is welcome!
Regards.

I would go with the second one : Option 2: Create multiple models.. Though, your organization about tables seemed complicated to me. Especially this part:

Code:

$responseData = [
    'column1' => table1Data['table1Column1'],
    'column2' => table2Data['table2Column2'],
    'column3' => table3Data['table3Column4'],

Hello, thank you very much for taking the time to answer.
Maybe with generic names it is complicated the issue of tables.
Actually all tables are related. For example:

Code:

transaction
id (PK)
date_time
...

receipt
id (PK)
code
product_id (FK)
dispatcher_id (FK)
broker_id (FK)
recipient_id (FK)
...

product
id (PK)
code
name
...


client
id (PK)
name
surname
adress
phone
...

As I need all the data the SQL query would be something similar to this:

Code:

SELECT transaction.id AS transaction_id,
      transaction.date_time AS transaction_date_time,
      receipt.code AS receipt_code,
      product.code AS product_code,
      product.name AS product_name,
      dispatcher.name AS dispatcher_name,
      dispatcher.surname AS dispatcher_surname,
      dispatcher.adress AS dispatcher_adress,
      dispatcher.phone AS dispatcher_phone,
      broker.name AS broker_name,
      broker.surname AS broker_surname,
      broker.adress AS broker_adress,
      broker.phone AS broker_phone,
      addressee.name AS addressee_name,
      addressee.surname AS addressee_surname,
      addressee.adress AS addressee_adress,
      addressee.phone AS addressee_phone
FROM transaction
JOIN product ON (product.id = transaction.product_id)
JOIN client AS dispatcher ON (dispatcher.id = transaction.dispatcher_id)
JOIN client AS broker ON (broker.id = transaction.broker_id)
JOIN client AS addressee ON (adressee.id = transaction.adressee_id)

Actually there are a few more tables involved, but I think you get the picture.
In other endpoints I need to update multiple tables, either adding records or updating some existing ones.

Create abstraction class/method, getMultiData(), getByCriteria().. Hide your query in this method. 
When you don't like your query, just change it in the method. This will not affect the code

Simple CI 4 project for beginners codeigniter-expenses ( topic )