Thinkphp5.0 join（tp5 join）

Db::table('think_artist')

->alias('a')

->join('think_work w','a.id = w.artist_id')

->join('think_card c','a.card_id = c.id')

->select();


$join = [

    ['think_wk w','a.id = w.artist_id'],

    ['think_cd c','a.card_id = c.id'],

];

Db::table('think_user')->alias('a')->join($join)->select();




Db::table('think_artist')

->alias('a')

->join('__WORK__ w','a.id = w.artist_id')

->join('__CARD__ c','a.card_id = c.id')

->select();

$list = Db::name('merchant_order')->alias('a')
                ->join('merchant_member mm', 'mm.id=a.member_id', 'LEFT')
                ->where($whereStr)
                ->field($file)
                ->order(['a.create_time' =>