public static function getcate( $id ){
return self::where('id',$id)->relation(['recate'=>function($query){
$query->relation(['reserver'=>function($query){
$query->relation('reitems');
}])->order('orderby');
},'resubbranch'])->find();
}
我用多对多关联 但是报错了

Database Status
Error Code
10501

Error Message
SQLSTATE[42000]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near the keyword 'pivot'.

Error SQL
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [re_item].*,pivot.id AS pivot__id,pivot.server_id AS pivot__server_id,pivot.item_id AS pivot__item_id FROM [re_item] INNER JOIN [re_server_re_item] [pivot] ON [pivot].[re_item_id]=[re_item].[id] WHERE [pivot].[re_server_id] = '1') AS thinkphp) AS T1