Select Id,Name, Directory__c,Folder_Template__c,Parent_File_Folder__c,(Select Id,Name, Directory__c,
         Folder_Template__c,Parent_File_Folder__c FROM Sub_Contractor__r WHERE Parent_File_Folder__c != null ORDER BY Parent_File_Folder__c Nulls First)
         FROM Contractor__c  WHERE Parent_File_Folder__c = null AND  File_Folder__c.Directory__r.Directory_Template__r.Active__c = true 
         ]

gridData;
    
    @track gridData;
    @track error;
    @track gridColumns = [{
        type: 'text',
        fieldName: 'Name',
        label: 'Folders'
     },
     {
         type: 'button',
         typeAttributes: {
             label: 'View'
         }
    }];
  

    @wire(fetchfolders)  
    folderTreeData({ error, data }) {

        if (data) {

            if (data) {
                let parseData = JSON.parse(JSON.stringify(data));
    
                for (let i = 0; i < parseData.length; i++) {
                    parseData[i]._children = parseData[i]['Sub_Contract__r'];
                    delete parseData[i]['Sub_Contract__r'];
                }
    
                this.gridData = parseData;
            } else if (error) {
                console.log('error ====> ' + JSON.stringify(error));
            }
        }
    }