$viewer = Engine_Api::_()->user()->getViewer();
$iCurUser = $viewer->getIdentity();
$oSelect = $this->getAdapter()->select()
->from(‘engine4_job_usersapplied’, array(‘job_id’, ‘COUNT(job_id) as applied_count’))
->group(‘job_id’)
->where(‘job_user = ?’, $iCurUser);
$result = $this->getAdapter()->fetchAll($oSelect);