How to get values by coincidence?

I have a record:
created_at user_id car_id count
26 1 - -
27 1 - -
27 8 - -

I need to get the users who have the same car_id knowing only user_id. How can I do that?
because I write user_id IN (1, 8) displays 3 records.
June 8th 19 at 16:56
1 answer
June 8th 19 at 16:58
Solution
SELECT
*
FROM tablename t 
JOIN tablename t2 ON t2.user_id IN (1, 8) AND t2.user_id != t.user_id AND t2.car_id = t.car_id
WHERE t.user_id IN (1, 8)

Find more questions by tags MySQLSQL