use Illuminate\Support\Facades\DB;

$articles = DB::table(‘articles‘)->join(‘category‘,‘articles.cateid‘,‘=‘,‘category.id‘)->select(‘articles.*‘,‘category.name‘)->get();

重点，一定记得select语句写上

laravel关联两个表内容取出的办法