How can I get all the Order Items in data Extension  

Query :  

SELECT 

    p.[FirstName], 

    p.[LastName], 

    p.[Id], 

    p.[Name], 

    p.[PersonContactId], 

    p.[PersonEmail], 

    p.[Membership_End_Date__c], 

    m.[Auto_Renew_Formula__c], 

    p.[Is_Member__c], 

    p.[PersonId__c], 

    p.[Deceased__c], 

    p.[Exclude_From_Renewal_Letters__c], 

    p.[Credit_Card_Expiration_Date__c], 

    p.[Member_Type__c], 

    p.[Membership_status__c], 

    p.[IsPersonAccount], 

    p.[Continuous_Member_Since_At_Least_Date__c], 

    p.[Exclude_From_Mail__c], 

    p.[AANP_Membership__c], 

    p.[Exclude_From_Email__c], 

    p.[PersonHasOptedOutOfEmail], 

    o.[TotalAmount], 

    o.[OrderNumber], 

    oi.[OrderId], 

    oi.[Product2Id], 

    pr.[Name] AS Product_Name, 

    pm.[Name] AS Payment_Method_Name, 

    pm.[ChargentBase__Card_Expiration_Month__c], 

    pm.[ChargentBase__Card_Expiration_Year__c], 

    pm.[ChargentBase__Card_Last_4__c], 

    pm.[ChargentBase__Card_Type__c], 

    co.[ChargentOrders__Charge_Amount__c], 

    co.[ChargentOrders__Payment_Start_Date__c], 

    co.[ChargentOrders__Payment_Status__c], 

    DATEDIFF(day, GETDATE(), p.[Membership_End_Date__c]) AS [Days_To_Expire] 

FROM [Person Account Master DE] p 

LEFT JOIN Membership__c_Salesforce m 

    ON p.[AANP_Membership__c] = m.[Id] 

LEFT JOIN ChargentBase__Payment_Method__c_Salesforce pm 

    ON p.[Auto_Renewal_Payment_Method__c] = pm.[Id] 

LEFT JOIN Order_Salesforce o 

    ON m.[Order__c] = o.[Id] 

LEFT JOIN OrderItem_Salesforce oi 

    ON o.[Id] = oi.[OrderId] 

LEFT JOIN Product2_Salesforce pr 

    ON oi.[Product2Id] = pr.[Id] 

LEFT JOIN ChargentOrders__ChargentOrder__c_Salesforce co 

    ON o.[Id] = co.[Standard_Order__c] 

WHERE 

    DATEDIFF(day, GETDATE(), p.[Membership_End_Date__c]) = 14 

    AND p.[Auto_Renew__c] = 'true' 

    AND p.[Is_Member__c] = 'true' 

AND p.[Deceased__c] ='false' 

    AND p.[Membership_Status__c] = 'Active' 

    AND p.[IsPersonAccount] = 'true' 

    AND p.[PersonEmail] IS NOT NULL 

    AND p.[Credit_Card_Expiration_Date__c] IS NOT NULL 

    AND p.[Credit_Card_Expiration_Date__c] > p.[Membership_End_Date__c] 

Based on abovve Query I m getting Exact Record In Query Editor the Same resullt I want to have In DE as well but what happening instaed i m Getting Only 1 Result in DE