Eloquent - 查看表1的数据，同时具有表3的PK

Question

I am new to Laravel/Eloquent. I have a question about accessing data from a table. The db structure is

1. Table 1 (I want to load this table)
   • No FK to any other table.
2. Table 2
   • Contains FK to Table 1
3. Table 3 (I have the PK for this table, when I need data for Table 1)
   • Contains FK to Table 2

I am not sure how should the Model for Table 1 look like, as I don't have any PK or FK for that table.

Many Thanks!

Answer 1

If I understood correctly, Model3 belongs to Model2 which belongs to Model1. So, do something like this to get Model1 data by PK from Model3:

$table1Data = Model3::find($pk)->relationToModel2()->first()->relationToModel1()->first();

Or by using whereHas() method:

$table1Data = Model1::whereHas('relationToModel2', function ($q) use ($pk) {
    $q->whereHas('relationToModel3', function ($q) use($pk) {
        $q->where('id', $pk);
    });
})->first();