select u.id UserID,
CASE
WHEN l.id IS NULL THEN false
ELSE true
END as 'Like',
CASE
WHEN c.id IS NULL THEN false
ELSE true
END Comment,
CASE
WHEN r.id IS NULL THEN false
ELSE true
END Retweet
from tweets t
LEFT JOIN users u ON t.userid = u.id
LEFT JOIN likes l on t.id = tweetid
LEFT JOIN comments c ON t.id = tweetid
LEFT JOIN retweets r ON t.id = r.tweetid
where u.id =: user_id