$this->model->
where('pid',0)
->order('sort')
->column('id')

除了column，select，find等方法都不行，都会出现
SQLSTATE[42S22]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]列名 'sort' 无效。

SQL打印出来是：
SELECT T1.* FROM
(
SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sort] DESC) AS ROW_NUMBER FROM
(
SELECT [id] FROM [t_product_category]
WHERE ( [pid] = 1 AND [delete_time] IS NULL ) AND [t_product_category].[delete_time] IS NULL) AS thinkphp
) AS T1;


其中 ROW_NUMBER() OVER ( ORDER BY [sort] DESC) AS ROW_NUMBER
放在 thinkphp 查询体中就可以。
但是放在T1中，就会出现，列名无效。

哪位大神有遇到。如何解决这个坑。