SELECT * FROM messages
INNER JOIN users ON users.id = messages.author
INNER JOIN followers ON followers.main_user = 2
WHERE messages.author = followers.followed_user OR messages.author = 2
ORDER BY date DESC;