2017-10-13T08:44:01Z||2017-10-13T08:44:01Z


逻辑关系很简单:两个表:一个user存用户,一个user_follow用户的关注关系。user_follow里只有两个列,src_iddest_id,也就是src_id关注了dest_id。现在要用SQL直接输出谁关注了谁,

MySQL:

select src.name, dest.name 
from user_follow f
inner join user src on src.id = f.src_id
inner join user dest on dest.id = f.dest_id