I am trying this code, that works well.
Code:
SELECT U.username, U.update_photo
FROM users U

INNER JOIN lists_has_users H 
ON U.id_user = H.users_id_user

INNER JOIN lists L
ON L.id_lists = H.lists_id_lists

WHERE L.users_id_user = ?
Now the problem. This query will select all the users of the lists. What i want is limit the number of output members by list.

For example, two members by each list (id_lists).

Any idea? thanks