mysql 将另一个表的行作为查询中的列连接起来

Question

我有两个表:users 和 user_meta。我想在与常规用户信息相同的查询中获取用户的所有元行。如何连接 user_meta 表中的行，这些行将像第一个表中的列一样工作？

user_meta:user_id(int 15)，上下文(varchar 250)，值(varchar 250)

       SELECT 
             m.user_id AS id, m.member_group_id, m.avatar_id, m.display_name, m.email_address, UNIX_TIMESTAMP(m.join_date) AS join_date, m.status,
             l.member_id, COUNT(l.member_id) AS total_listings,
             g.group_id, g.title AS group_title,
             a.attachment_id, a.file_path AS avatar_path
        FROM users AS m
        LEFT JOIN user_meta AS meta ON m.user_id = meta.user_id
        LEFT JOIN listings AS l ON l.member_id = m.user_id
        LEFT JOIN groups AS g ON m.member_group_id = g.group_id
        LEFT JOIN attachments AS a ON m.avatar_id = a.attachment_id
        WHERE m.user_id = ".$id."
        GROUP BY m.user_id
        LIMIT 1

Answer 1

只需尝试这个m.user_id AS id ORDER BY ASC