I believe this should be really simple but for some reason it's not.

I have tables

```
student 
|id|name|...etc

school
|id|name|....etc

school_student
|id|school_id|student_id

```

Student Model

```
public function schools()
{
    return $this->belongsToMany('School');
}

```

School Model

```
public function students(){
    return $this->belongsToMany('Student');
}

```

I would simply like to output students who belong to school\_id=1 for example.

In other words:

```
    SELECT * FROM students LEFT JOIN school_student ON student.id=school_student.student_id WHERE school_id='1'

```

Using Laravel 4.1 . I'm fairly new to Laravel and maybe I have a mental blocks on this but have not managed to find a solution that works.

I tried several ways but all wrong. The basic without the school\_id search is:

```
      $students = Student::with('schools')->get();

```

Help appreciated.