How convenient to implement a many-to-many relationship?

Question

PostgreSQL

There are two tables. One with academic councils, and the other with specialties. A many-to-many relationship is organized through an intermediate table. The problem is that the query below results in duplicate council information for each specialty (see picture). Sending from the server and processing such information is not comme il faut (it would be more convenient if the specialties were in the list and occupied one line for each tip). What is the best solution in this situation?

SELECT branch_id, c.council_id, c.expiration_date, c.creation_date
    from council_branch cb
    INNER JOIN council c ON cb.council_id=c.council_id