Как использовать JOIN в Eloquent ORM?

Question

[Speakermen]

Доброго времени суток не пойму что не так возвращает 1 таблицу а не 2 вместе.

Использовал hasOne, belongsTo, hasMany, hasOneThrough. уважаемые программисты help кодеру please

Там ещё Personal Info, Hobbies and Interests, Education and Employement 3 таблицы будут которые относятся к id_user

Schema::create('users', function (Blueprint $table) {
            $table->id();
            $table->string('firstname');
            $table->string('lastname');
            $table->string('status')->nullable();
            $table->string('email')->unique();
            $table->timestamp('email_verified_at')->nullable();
            $table->string('password');
            $table->string('birthday')->nullable();
            $table->enum('gender', [1, 2]);
            $table->string('profile_photo')->default('/img/author-main1.jpg');
            $table->string('header_photo')->default('/img/top-header1.jpg');
            $table->rememberToken();
            $table->timestamps();
        });

//Personal Info
Schema::create('abouts', function (Blueprint $table) {
            $table->id();
            $table->string('about_me')->nullable();
            $table->string('birthplace')->nullable();
            $table->string('lives_in')->nullable();
            $table->string('occupation')->nullable();
            $table->string('joined')->nullable();
            $table->string('status')->nullable();
            $table->string('website')->nullable();
            $table->string('phone_number')->nullable();
            $table->string('religious_belifs')->nullable();
            $table->string('political_Incline')->nullable();
            $table->string('facebook')->nullable();
            $table->string('twitter')->nullable();
            $table->string('rss')->nullable();
            $table->string('dribbble')->nullable();
            $table->string('spotify')->nullable();
            $table->integer('user_id')->unsigned();
            $table->timestamps();
        });

SELECT abouts.about_me, abouts.birthplace, abouts.lives_in, abouts.occupation, abouts.joined, abouts.website, abouts.phone_number, abouts.religious_belifs, abouts.political_Incline, abouts.facebook, abouts.twitter, abouts.rss, abouts.dribbble, abouts.spotify, users.firstname, users.lastname, users.email, users.birthday, users.gender
FROM abouts
   INNER JOIN users
      ON abouts.user_id = users.id;

Comments

[Speakermen]

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\User;
use Illuminate\Support\Facades\DB;

class AboutsController extends Controller
{
    protected int $user_id;

    public function show(User $id)
    {
        $this->user_id = $id->id;

        $user = DB::table('users')
            ->join('hobbies', 'users.id', '=', 'hobbies.user_id')
            ->join('personal_informations', 'users.id', '=', 'personal_informations.user_id')
            ->join('educations', 'users.id', '=', 'educations.user_id')
            ->select(
                'users.id', 
                'users.firstname',
                'lastname',
                'status',
                'email',
                'birthday',
                'gender',
                'profile_photo',
                'header_photo',
                'hobbies.*', 'personal_informations.*', 'educations.*')
            ->where('users.id', $this->user_id)
            ->first();

        return view('profile.about', compact('user'));
    }
}

[Alex Wells]

Speakermen, с какого хрена использовать join'ы, когда есть релейшены?

https://laravel.com/docs/8.x/eloquent-relationships

[Speakermen]

Alex Wells, я не могу переписать результат другой(

[Alex Wells]

Speakermen, ну есстественно, что другой. Но судя по структуре, он и должен быть другой

[Speakermen]

Alex Wells, спасибо за подсказку