Mysql query from two interdependent tables

Question

MySQL

Table Users and Comments
It is necessary to display a list of users who wrote the last comments.
select * from comments as com
left join users as us on com.user_id=us.user_id
group by user_id order by com.date desc LIMIT 0,10
Displays not the latest by comments, but random ones.
if without group by
select * from comments as com
left join users as us on com.user_id=us.user_id
order by com.date desc LIMIT 0,10
then it shows users repeats if they wrote the last 2 comments.
help me please

Answer 1

Try "distinct user_id".

Answer 2

If you need users exactly, then it will be more convenient to take the main query table users:

select distinct us.* from users us
inner join comments com on com.user_id = us.user_id
order by com.date

Answer 3

try group by com.user_id