Is it possible to join 2 tables so that 1 doesn't have duplicate values?

Question

MySQL

There are 2 tables, one for displaying text about the author, the second for displaying social icons, I want to add or remove from the admin panel, but:

SELECT `about_id`, `about_image`, `about_name`, `about_who`, `about_description`, `about_text` FROM `about_us`

SELECT `about_social_id`, `about_social`, `about_social_image` FROM `about_social`

I initially implemented LIMIT 1 to 1 so as not to repeat the other, left it the same way and stuffed everything into an array, but I think that this is a wrong implementation.
If I use JOIN, then in 1 table everything is repeated, and 2 are normal
SELECT * FROM `about_us` JOIN `about_social`

Answer 1

Probably like this: www.emrahacikgoz.com.tr/wp-content/uploads/2016/12... it will be clear