上面是数据表结构
下面是我的查询语句
$test = $school->join(' xsgj_users ON xsgj_school.userId = xsgj_users.userId')->select();
就是查出来是空值，改成left join也出不来，数据表名称改成大写的也不行，不会因为SqlServer的缘故吧？
发现最后一条执行的查询语句是SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [xsgj_school] INNER JOIN xsgj_users ON xsgj_school.userId = xsgj_users.userId) AS thinkphp) AS T1