How to get one of two identical records in a table?

Question

MySQL

Hello.
I join two tables in Laravel like this:

->leftJoin('articles_categories','articles.id','articles_categories.id_article')

However, the 'articles_categories' table has two 'articles_categories.id_article' entries for each 'articles.id'.
How to get only one of them?

Answer 1

Add Limit = 1. I'm not very familiar with the syntax of this DBMS, but I think it will be something like this:

->leftJoin('articles_categories','articles.id','articles_categories.id_article')->limit(1)->get();

Answer 2

the data structure is not clear, it is not clear what you want to get. and there can be many
distinct()
first()
limit(1)
groupby()