It looks like you want to join the two tables together like the following
select t.* from TweetTable t left join FollowerTable F on t.userid = f.followTOid where t.userid = @userid
There are different types of joins and your old friend google, will have lots of information on this subject