Mysql一对多

select * from l1 left join s1 on l1.s1_nid = s1.nid
left join color on l1.cos = color.nid
where s1.pray = 'CEO';

　　

多对多