该列在选择列表中无效，因为该列未包含在聚合函数或GROUP BY子句中

试试这个-

SELECt       node.GroupName    , depth = COUNT(parent.GroupName) - 1FROM CompanyGroup nodeJOIN CompanyGroup parent ON node.LeftID BETWEEN parent.LeftID AND parent.RightIDGROUP BY node.GroupNameORDER BY MIN(node.LeftID) --<--

或者尝试一下-

SELECt       node.GroupName    , depth = COUNT(parent.GroupName) - 1FROM CompanyGroup nodeJOIN CompanyGroup parent ON node.LeftID BETWEEN parent.LeftID AND parent.RightIDGROUP BY node.GroupName, node.LeftIDORDER BY node.LeftID