PHP app Review::join 예제들

 public function reviews(Request $request)
 {
     if ($request->has('type')) {
         $type = $request->input('type');
     } else {
         $type = 0;
     }
     if ($type < 0) {
         $reviews = Review::join('dramas', 'reviews.drama_id', '=', 'dramas.id')->where('reviews.visible', '=', 1)->select('reviews.*', 'dramas.title as drama_title')->orderBy('id', 'desc')->simplePaginate(20);
     } else {
         $reviews = Review::join('dramas', 'reviews.drama_id', '=', 'dramas.id')->where('dramas.type', '=', $type)->where('reviews.visible', '=', 1)->select('reviews.*', 'dramas.title as drama_title')->orderBy('id', 'desc')->simplePaginate(20);
     }
     $reviews->load(['user' => function ($query) {
         $query->select('id', 'name');
     }]);
     $reviews->load(['episode' => function ($query) {
         $query->select('id', 'title');
     }]);
     return view('review.reviews', ['reviews' => $reviews]);
 }