在Laravel中使用Query Builder进行外键查询？

Question

I am wondering if it is possible or not to reference a foreign key to a table using the Query Builder instead of using Eloquent relationships.

I am looking at Laravel Documentation where we can create foreign key

Schema::table('posts', function (Blueprint $table) {
    $table->unsignedInteger('user_id');

    $table->foreign('user_id')->references('id')->on('users');
});

But I don't see in query builder if it is possible to just use the foreign key or references to get all the posts from a user

Do I have to use Eloquent relationships?

Thanks in advance for any help.

Answer 1

Use join to query for relations:

$users = DB::table('users')
        ->join('posts', 'users.id', '=', 'posts.user_id')
        ->select('users.*', 'posts.*')
        ->get();