How to UNION Craft blog articles array with Social Media plugin (non craft table)
More of general guidance than an answer, but I'd look into creating a custom ElementType and overriding the modifyElementsQuery in your ElementType to latch onto the main query Craft uses to grab elements.  From there you'd be able to join in whatever other data you need.