// 查询数据 //thinkphp5 使用原始 sql 的方法 //$result = Db::query('select * from tp_ex_users_level where 1 = 1'); $level = Db::query(" select * from tp_ex_users_level a " ." left join tp_ex_point b on b.level = a.level " ." where a.p_user_id = :p_user_id and a.user_id = :user_id ", Array( "p_user_id"=>$p_user_id, //这个是登录用户的 id "user_id" =>$user_id //$v["user_id"] //这个是订单的用户 id ));