mysql in_id is_MySQL Column 'id' in IN/ALL/ANY subquery is ambiguous

I am trying to do a search functionalities that involves three tables.

Searching for users and returning wheather the user id 1 is a friend of the returned users. Also The returned users is being filtered from a third table where it checks tag of that users.

So I can say, "Return users who has tag 'Programming', 'Php' in userinterests table and also if the returned user is a friend of usr id 1 or not "

I am trying to use the bellow query but getting Column 'id' in IN/ALL/ANY subquery is ambiguous If I remove the left join then it works.

SELECT n.id, n.firstName, n.lastName, t.id, t.tag, t.user_id, if(id in (

SELECT u.id as id from friends f, users u

WHERE CASE

WHEN f.following_id=1

THEN f.follower_id = u.id

WHEN f.follower_id=1

THEN f.following_id = u.id

END

AND

f.status= 2

), "Yes", "No") as isFriend

FROM users n

LEFT JOIN userinterests t on n.id = t.id

WHERE t.tag in ('Programming', 'Php')

Thank you for your time :)