调用未定义的方法 Illuminate\Database\Query\Builder：：join( "branches" ， "branches.id" ， "users.branc

Question

$query = DB::table("public.users")->join("branches",function($join){$join->on("branches.id", "=", "users.branch_id");})->get;
dd($query());

调用未定义的方法 Illuminate\Database\Query\Builder：：join("branches"，"branches.id"，"users.branch_id"(->get((

幼虫显示查询结果

Answer 1

try to remove public from the query.
$query = DB::table("users")->join("branches",function($join){$join- 

on("branches.id"， "="， "users.branch_id"(;}(->得到;

Answer 2

$query = DB::table('users')
->join('contacts', 'users.id', '=', 'contacts.user_id')
->get();