SysGoods::notorm() ->alias(‘a‘) ->leftJoin(‘goods_category‘,‘b‘,‘a.category_id = b.id‘) ->select(‘a.id,a.name,b.name c_name‘);
关联查询
原文:https://www.cnblogs.com/CanyingV/p/15044567.html