PHP查询还显示ID 75的结果

I have the following query. For some reason it's not showing results for the user under id: 75, which is me of course.

SELECT IF(friends.sender = 75, friends.recipient, friends.sender) AS id, users.firstname, users.lastname, feed.date, feed.time, feed.text, feed.userID, feed.ip
FROM friends
JOIN users
    ON (users.id = IF(friends.sender = 75, friends.recipient, friends.sender))
JOIN feed 
    ON (users.id = feed.userID)
WHERE friends.sender = 75
    OR friends.recipient = 75
 AND friends.status = 1
ORDER BY feed.date DESC, feed.time DESC

Taking a little bit of a guess at what you're attempting to accomplish, but assuming you want to return a list of users and their friends, something like this should work:

SELECT DISTINCT users.id, users.firstname, users.lastname, 
    feed.date, feed.time, feed.text, feed.userID, feed.ip
FROM users 
JOIN friends
    ON users.id IN (friends.sender, friends.recipient)
JOIN feed 
    ON (users.id = feed.userID)
WHERE 75 IN (friends.sender,friends.recipient) 
    AND friends.status = 1
ORDER BY feed.date DESC, feed.time DESC

• Condensed SQL Fiddle Demo