Three table conditional left join

doing a three table conditional left join in mysql using a subquery

"select * from newsletters
left join
(preferences,
(select * from users where users.id=#{id}) as user)
on (preferences.newsletter_id=newsletters.id
and preferences.user_id=user.id)"