Fix: how to get results like eloquent with relation using query builder?

 In Laravel, Eloquent provides a convenient way to retrieve results with relationships using its built-in ORM capabilities. However, if you want to achieve similar results using the query builder instead of Eloquent, you can do so by manually constructing the queries to join related tables and select the desired fields. Here's a general example of how to use the query builder to retrieve results with relationships:

Assuming you have two tables, "posts" and "comments," where "posts" has a one-to-many relationship with "comments" (each post can have multiple comments).

```php

use Illuminate\Support\Facades\DB;

$results = DB::table('posts')

    ->select('posts.id as post_id', 'posts.title', 'comments.id as comment_id', 'comments.text')

    ->join('comments', 'posts.id', '=', 'comments.post_id')

    ->get();

```

In this example:

1. We select the fields we want from both the "posts" and "comments" tables, aliasing them as needed to avoid naming conflicts.

2. We use the `join` method to join the "comments" table with the "posts" table using the foreign key relationship, in this case, `posts.id` and `comments.post_id`.

3. Finally, we call `get()` to execute the query and retrieve the results.

The resulting `$results` variable will contain an array of objects with properties like `post_id`, `title`, `comment_id`, and `text`, which correspond to the fields we selected from the query.

Remember that the specific table and field names will vary depending on your database schema and relationships. You should adjust the query to match your database structure and the relationships you want to retrieve. This approach allows you to retrieve results with relationships using the query builder in Laravel, but it may involve more manual work compared to using Eloquent's built-in relationship capabilities.