is like this, and the ultimate effect is to match the avatar address of the drink in the user table for each comment list
first, query out the table_1 (article comment table) article comment result set
then I found that these comments do not have user avatars, so I need to associate the table_2 (user table) of the query. In this place, the reply_user in the result set of the first comment query is associated with the username in the table_2 (user table).
the user avatar to be queried is in the avatar_link field of table_2 (user table)
then merge the list of comments and the corresponding avatar (each comment corresponds to a different user avatar)
solve the problem, sql is not good at learning