How to create a node based on views results
I think you need 2 relationships in Views. One that targets your field that points from user to the campaing. Second, with the author, based on the first relationship.
After, add as fields user names.
Not really sure about your structure so that was just a supposition.