How to get particular column in zend using Left join

I am new to zend framework,

Following is the plain mysql query which takes particular column from table,

SELECT jobs_users.id,jobs_users.first_name from jobs_users left join friends on jobs_users.id=friends.friend_id where friends.member_id=29

I tried with zend to implement the above query like below,

public function getFriendsProfileList($id){

           $db = Zend_Db_Table::getDefaultAdapter();

$select = $db->select();
$select->from('jobs_users')
        ->joinLeft(
                'friends',
                'jobs_u开发者_运维知识库sers.id=friends.friend_id',
                array('jobs_users.id','jobs_users.first_name','jobs_users.last_name','jobs_users.photo')
                )
        ->where("friends.member_id = ?", $id);
$result = $db->fetchAll($select);
return $result;

    }

Here i got result with all column name , not with exact column name which i have given in query.

Kindly help me on this.

Use this instead:

$select->from('jobs_users', array('jobs_users.id','jobs_users.first_name','jobs_users.last_name','jobs_users.photo'))
->joinLeft('friends', 'jobs_users.id=friends.friend_id')
->where("friends.member_id = ?", '20');

You may also try this:

$select = $db->select();
$select->setIntegrityCheck(false);
$select->joinLeft('jobs_users','',array('jobs_users.id','jobs_users.first_name','jobs_users.last_name','jobs_users.photo'));
$select->joinLeft('friends','jobs_users.id=friends.friend_id', array());
$select->where("friends.member_id = ?", $id);
$result = $db->fetchAll($select);
return $result;