PHP & MySQL Error - Duplicate column name 'user_id'

[Tommy8x]

I get the following Error below from my query, and was wondering how can I fix this problem?\[code\]Duplicate column name 'user_id'\[/code\]Here is My MySQL query.\[code\]"SELECT COUNT(users_friends.user_id) FROM ((SELECT *FROM users_friendsINNER JOIN users ON users_friends.user_id = users.user_idWHERE users_friends.user_id = '" . $user_id . "' AND users_friends.friendship_status = '1')UNION(SELECT *FROM users_friendsINNER JOIN users ON users_friends.friend_id = users.user_idWHERE users_friends.friend_id = '" . $user_id . "'AND users_friends.friendship_status = '1')) as friends"\[/code\]Here is my new query.\[code\]SELECT COUNT(user_id) FROM ((SELECT users_friends.user_idFROM users_friendsINNER JOIN users ON users_friends.user_id = users.user_idWHERE users_friends.user_id = '" . $user_id . "' AND users_friends.friendship_status = '1')UNION(SELECT users_friends.user_idFROM users_friendsINNER JOIN users ON users_friends.friend_id = users.user_idWHERE users_friends.friend_id = '" . $user_id . "'AND users_friends.friendship_status = '1')) as friends\[/code\]