使用WITH common_table_expression的SQL查询在Codeigniter但不是SQL Studio中失败

I created a query in MS SQL Management Studio for SQL Server 2012 that uses common_table_expression to self join a table. It works correctly in MS SQL Studio but in Codeigniter no result or error is returned.I created a query in MS SQL Management Studio f