现在有个需求和同事争执了，就是根据企业编号和我的用户编号查询常用同事，哪位教主来指点一下，多谢

Question

SELECT
    a.username,
    a.head_img,
    cj.job
FROM
    (
        SELECT
            u.username,
            u.head_img,
            c.often_colleague_id,
            cpf.job_id
        FROM
            company_team_oftencolleague c,
            `user` u,
            company_personnel_file cpf
        WHERE
            c.often_colleague_id = u.id
        AND cpf.user_id = c.often_colleague_id --这是常用同表里常用同事用户编号，userid是企业人事表的
        AND cpf.`status` = 1
        AND c.company_id = 10043
        AND c.my_id = 57
    ) a
LEFT JOIN company_job cj ON cj.id = a.job_id
LIMIT 0,10;

company_team_oftencolleague这是常用同事表，user u 用户表，company_personnel_file 企业人事表，company_job cj 企业职位表;
以上是我同事写的，下面是我写的：

SELECT
    u.username,
    u.head_img,
    cj.job
FROM
    company_team_oftencolleague c
INNER JOIN `user` u ON c.my_id = u.id
INNER JOIN company_personnel_file f ON f.user_id = c.often_colleague_id
INNER JOIN company_job cj on cj.id=f.job_id
where f.`status`=1 and c.company_id=10043 and c.my_id=57;