laravel跨库jion查询

首先laravel跨库需要设置2个库，通过在env和database.php中设置

查询

$dbExam = env('DB_EXAM_DATABASE', 'xxx');
        $dbLegal = env('DB_DATABASE', 'xxx');
        $data = DB::table($dbExam.'.x2_examhistory as emh')
                ->select(DB::raw('lli.name, lli.idcard, lli.phone, lls.name,lli.created_at,llu.nick_name,emh.ehusername, emh.ehexam, emh.ehscore score, emh.ehtime, FROM_UNIXTIME(emh.ehstarttime,"%Y-%m-%d %H:%i:%s") as ehstarttime'))
                ->leftJoin($dbExam.'.x2_user as emu', 'emu.userid', '=', 'emh.ehuserid')
                ->leftJoin($dbLegal.'.users as llu', 'llu.openid', '=', 'emu.useropenid')
                ->leftJoin(DB::raw('(SELECT * FROM '.$dbLegal.'.exam_user_infos GROUP BY id ) lli'), 'lli.user_id', '=', 'llu.id')
                ->leftJoin(DB::raw('(SELECT * FROM '.$dbLegal.'.state_organs GROUP BY id) lls'), 'lli.state_organ_communty', '=', 'lls.id')
                ->where('llu.id', $userId)
                ->groupBy('emh.ehuserid')
                ->orderBy('emh.ehid')
                ->limit(10000)
                ->get();