How to link 4 tables in laravel ORM?

Question

ORM

There are 4 tables:
transport_types

• id
  
• name
  

body_transport_types

• id
  
• body_id
  
• transport_type_id
  

bodies

• id
  
• slug
  

body_descriptions

• id
  
• name
  
• body_id
  
• language_id
  

and there is a model

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Transport_type extends Model
{


    public static function callId( $id )
    {
        return self::whereId( $id ) -> firstOrFail();
    }

    public function bodies( $language_id = null )
    {
     }
}

you need to connect 4 tables with one query, so that it looks something like this:

$bodies = Transport_type::callId( 6 ) -> bodies ( 1 ) ;

and the $bodies variable had names in the appropriate language

Answer 1

Alternatively, polymorphic relationships.