在Laravel中加入3张桌子 [英] Join 3 Tables in Laravel

问题描述

我有三个表:

notes: id, business_id, note

businesses: id, title, description

businessimages : id, business_id, image

我想获得notes.id, businesses.id, businesses.title, businesses.description, businessimages.image

我该怎么办?

推荐答案

$data = DB::table('businesses')
            ->join('notes', 'notes.business_id', '=', 'businesses.id')
            ->join('businessimages', 'businessimages.business_id', '=', 'businesses.id')
            ->select('businesses.*', 'notes.note', 'businessimages.image')
            ->get();

这篇关于在Laravel中加入3张桌子的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！