How to relate the same table without conflict?

Question

I have a user table, and a likes table. The table of likes has: usuario_curtido and usuario_curtiu.

When I execute

select u.usuario_nome from usuarios u
JOIN te_curtidas_usuarios c
ON c.curtida_usuario_curtido = u.usuario_id
ORDER BY c.curtida_data LIMIT 15

users clash - I always get the same user.

Answer:

array(7) {
  [0]=>
  array(1) {
    ["usuario_nome"]=>
    string(11) "Maria Joana"
  }
  [1]=>
  array(1) {
    ["usuario_nome"]=>
    string(16) "Daniel Bonifacio"
  }
  [2]=>
  array(1) {
    ["usuario_nome"]=>
    string(16) "Daniel Bonifacio"
  }
  [3]=>
  array(1) {
    ["usuario_nome"]=>
    string(16) "Daniel Bonifacio"
  }
  [4]=>
  array(1) {
    ["usuario_nome"]=>
    string(16) "Daniel Bonifacio"
  }
  [5]=>
  array(1) {
    ["usuario_nome"]=>
    string(16) "Daniel Bonifacio"
  }
  [6]=>
  array(1) {
    ["usuario_nome"]=>
    string(15) "Daniel Oliveira"
  }
}

Table:

Answer 1

Update

From what I understand you’re not relating the same table, you’re relating the table usuarios with te_curtidas_usuarios through JOIN. In this case they will return all occurrences of the second table curtida_usuario_curtido in which curtida_usuario_curtido is equal to usuario_id, repeating the names usuario_nome which are on the first table usuarios.

To prevent the same user from being repeated, you should group the result of the query by id user using GROUP BY:

select u.usuario_nome from usuarios u
JOIN te_curtidas_usuarios c
ON c.curtida_usuario_curtido = u.usuario_id
GROUP BY u.usuario_id
ORDER BY c.curtida_data LIMIT 15