Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

Oct 7, 2022

19

OP

Level 1

Displaying user information from the same table

Greetings, well I have a single table called users which has id and supervisor _id. The table is used for both students and supervisors. When i assigned a student a supervisor, the user id will be inserted as supervisor id. Now i want to display the info on a single like below. So i was wondering how would i go about into developing a laravel query that i will be able to display students and supervisors names. I managed to display student names and supervisor_id

STUDENT SUPERVISION Table SN |Student Name |Supervisor | 1 James Frank 7

Below is what i managed so far

   $student =DB::tables('users')
   ->where('usertype','=','student')
   ->get();

the view

        @foreach ($submitted as $project)
          <tr>
            <td>{{++$sno}}</td>
            <td>{{$student->firstname}} {{$student->lastname}}</td>
            <td>{{$student->supervisor_id}}</td> HERE  i want to display supervisor name. INSTEAD OF THEIR ID

. Assign @endforeach

Best Answer

Level 102

Why not just use eloquent?

   $student = User::where('usertype','=','student')
  ->with('supervisor')
   ->get();

and

@foreach ($submitted as $project)
          <tr>
            <td>{{++$sno}}</td>
            <td>{{$student->firstname}} {{$student->lastname}}</td>
            <td>{{$student->supervisor->name ?? 'No supervisor'}}</td> 
         </tr>
@endforeach

For it to work you need to add this to the User model

public function supervisor()
{
    return $this->belongsTo(User::class, 'supervisor_id');
}

OP

Level 1

@Sinnbeck okay let me try

OP

Level 1

@Sinnbeck I get this error

Call to undefined method Illuminate\Database\Query\Builder::with()

Level 102

@ghaonga Read my code again. Notice I use User::where() instead of DB::table()

OP

Level 1

@Sinnbeck this is want i wrote public function supervise($id) {

    $student = User::with('supervisor')->where('usertype','=','student')       
    ->get();
    return view('admin.assign', compact('student'));
}

Level 102

@ghaonga That should work. Personally I would name it $students as you are getting all students, not just one

1 like

OP

Level 1

@Sinnbeck But the other thing, it is just a single table Users , there is no supervisor table. Could that be a reason? Example is the table below. I want to be able to display names of supervisor as well when i display data of students . Such as SN StudentName SupervisorName

    ID Name Usertype Supervisor
    1. Godfrey  Student   3
   2.  Jeff Student       3
   3.  Frank  tutor       null

Level 102

@ghaonga yeah I completely understand what you mean. My code is written for that exact structure

OP

Level 1

@Sinnbeck well thank you for your help, but it stills producing the same error.

Level 102

@ghaonga what error and on what line?

1 like

OP

Level 1

         @foreach ($students as $student)
          <tr>
            <td>{{++$sno}}</td>
            <td>{{$student->firstname}} {{$student->lastname}}</td>
           
            <td>{{$student->supervisor->firstname ?? 'No supervisor'}}</td> 
            <td>
              <a href="/user-assign/{{$project->userid}}" class="btn btn-default">Assign</a>
            </td>
          </tr>
          @endforeach

OP

Level 1

Bad Method Call

Did you mean Illuminate\Database\Query\Builder::when() ?

Level 102

@ghaonga on what line? It should be clearly shown

1 like

OP

Level 1

@Sinnbeck Illuminate\Database\Query\Builder::throwBadMethodCallException C:\xampp\htdocs\fypms\vendor\laravel\framework\src\Illuminate\Support\Traits\ForwardsCalls.php:71

Level 102

@ghaonga can you share the error page? I assume there is a share button on the page?

OP

Level 1

@Sinnbeck https://flareapp.io/share/DPyO90R5#F52

Level 102

@ghaonga you are still using DB

$submitted = User::query()
        ->join('project', 'project.userid', '=', 'users.id')
        ->with('supervisor')
        ->get();

https://flareapp.io/share/DPyO90R5#F50

1 like

OP

Level 1

@Sinnbeck THANK YOU SO MUCH....Now it works

->with('supervisor')

I changed this to a new name, it was interfering with the existing supervisor column

Level 102

@ghaonga ah ok I thought it was supervisor_id. But great that it works :)

Please or to participate in this conversation.