示例表：
CREATE TABLE IF NOT EXISTS authors (
`author_id` INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
`name` VARCHAR(64) UNIQUE NOT NULL DEFAULT ''
) ENGINE INNODB COMMENT '作者表';
create table if not exists articles (
`article_id` int unsigned primary key auto_increment,
`title` varchar(64) unique not null default '',
`created_at` timestamp not null default CURRENT_TIMESTAMP,
`updated_at` timestamp not null default CURRENT_TIMESTAMP
)engine innodb comment '文章表';
create table if not exists author_article (
`article_id` int unsigned not null,
`author_id` int unsigned not null,
primary key (`author_id`,`article_id`)
)engine innodb comment '作者文章關(guān)聯(lián)表';
按照文章的最新發(fā)布時間查找對應(yīng)作者列表
SELECT
au.author_id AS author_id, au.name AS name
FROM
(authors AS au
LEFT JOIN author_article AS aa ON au.author_id = aa.author_id)
LEFT JOIN
articles AS ar ON aa.article_id = ar.article_id
ORDER BY ar.created_at DESC
