将sql联接查询转换为laravel

Question

SELECT school_courses.*, schools.school_name, schools.country, schools.city  FROM 
school_courses JOIN schools ON school_courses.school_id = schools.id

你好，

我想将上面的SQL查询转换为laravel。此外，我想学习laravel查询中的连接，请分享任何简单的分步教程链接(如果你有(。

Answer 1

这是查询生成器的方法。

$result = DB::table('school_courses')
->join('schools','schools.id','=','school_courses.school_id')
->select('school_courses.*','schools.school_name', 'schools.country', 'schools.city')
->get();

请参阅此链接https://laravel.com/docs/8.x/queries#joins

Answer 2

我的建议是使用更好的Eloquent:Relationships

关系

您的转换查询在下方给出

use IlluminateSupportFacadesDB;
$users = DB::table('school_courses')
->join('schools', 'us schools ers.id', '=', 'contacts.user_id')
->select('school_courses.*','schools.school_name', 'schools.country', 'schools.city')
->get();