I need a larval coder

We are trying to return results in a reports to structure, where only reporting users that share a common value (from two separate data tables) are displayed. We are using larvel. In the controller we are defining "Reporting Users" as users (from a common users table), who are active, report to another "user_id", who both share the exact same "scorecard_type_id" from ( $dbPrefix.'access_permissions' and $dbPrefix.'scored_in'). We have tried using an inner-join, but with errors. This is for a linux server, running MySQL, and PHP, under a larvel stack. Image of Scored_in table (column ids used: "userid" and "score_card_type_id): Image of Access_Permissions table (column ids used: "id" and "score_card_type_id"): For the Users Table: the Id that we are referencing is "id" There are three data tables that are used in this scenario, a common users table, a prefix database table for scored_in (this table defines the score_card_type_id users are scored in), and a prefix database table for access_permissions (this is the table that defines the score_card_type_id a user can score other users in) Where we are currently: You can see here Teacher 1 can see Student 2, and Student 3, but they should not be able to see that student 2 and Student three, in Teacher 2 or Teacher 3 classes, because Teacher 1 does not teach Student 2 or Student 3. What we want: We want to the user (Teacher 1) to only see Students that report to Teacher 1, and are scored_in the score_card_type_id(s) Teacher 1 has in access_permissions score_card_type_id(s) function getAllReportingUsers($userId, &$allUsers) { $dbPrefix = $this->getDBPrefix(null); $user_profiles = user_profile::join('users', '[login to view URL]', '=', 'user_profile.user_id') ->where('users.is_active', '=', 1) ->where('user_profile.reports_to', '=', $userId) // Shit! //->select(DB::raw('distinct('.$dbPrefix.'scored_in.score_card_type_id)')) //->where($dbPrefix.'scored_in.score_card_type_id', '=', $dbPrefix.'access_permission.score_card_type_id') ->get(); foreach ($user_profiles as $reportUserId){ $userReportTo_id = $reportUserId->user_id; if($userReportTo_id == $userId) { array_push($allUsers, $userReportTo_id); return false; } if($userReportTo_id>0){ array_push($allUsers, $userReportTo_id); $this->getAllReportingUsers($userReportTo_id, $allUsers); }else{ return false; } We would like the result to be the viewing user is only able to see reporting users whose "scorecard_type_id" from the "scored_in" data table = the viewing users "scorecard_type_id" from the access_permissions data table. We also want to add a column in ScoreCardType, that will make some of the rows "global" along with a permission that allows some users to see the global scorecards with only the users that report to them.