How do article tables and user tables usually relate

I am doing a blog, article list page entries, need to show the article title, plus the user name.
currently there is only the user"s id in the article table.
excuse me, how is it better to relate to user information in this case

Sql
Jun.15,2022

left join

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e6ed9d-20e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e6ed9d-20e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?