三表级联查询

SELECT tb_article.article_name,tb_type.type_name,tb_user.user_name 

FROM tb_article inner join tb_user on tb_article.userid=tb_user.user_phone 

inner join tb_type on tb_article.typeid=tb_type.id;

或

SELECT a.article_name,b.type_name,c.user_name 

FROM tb_user AS c  LEFT JOIN (tb_article AS a LEFT JOIN tb_type AS b ON 

a.typeid=b.id) ON a.userid=c.user_phone;