Şu şekilde dene bakalım.
SELECT content.*,polls.* FROM (SELECT c.id as 'contentID', c.title as 'contentTitle',c.username FROM forum_content as c WHERE c.username='{$user->username}') as content INNER JOIN (SELECT p.id as 'pollsID',p.title as 'pollsTitle',p.username FROM forum_polls as p WHERE p.username='{$user->username}') as polls ON content.username=polls.username---
Yada şunu
SELECT c.*,(SELECT p.id as 'pollsID',p.title as 'pollsTitle',p.username FROM forum_polls as p WHERE p.username='{$user->username}') as polls FROM forum_content WHERE c.username='{$user->username}')