[SalesForce] LWC is not working with non-admin profiles

I did something similar some time ago, but with the aura version of the component (take a look here)... you can implement the same idea easily in LWC, although with this approach you'll have to retrieve the related record to get the Name (you could use @wire and getRecord LDS wire adapter for that).

Edit: thinking about it I remembered a more recent implementation of the view you could take, this one, look at how I display ownerNameValue. Hope that helps.

You need to recreate the array using ES6 spread operator. LWC Data Table does not refresh view when push is used to add element to data property. I've updated wiredUsers method with the fix.

@wire(getRelatedUsers)
wiredUsers({data,error}){     
    if (data) {
        let usersArray = [];  
        data.forEach(user => {               
            let preparedUser = {};
            preparedUser.Name = user.name;              
            preparedUser.Email = user.email;              
            usersArray.push(preparedUser);
        });
        this.usersArray = [...usersArray];       
        this.loadedData = data;
    } else if (error) {
        this.error = error;
    }
}