Weblabor

$config = new Zend_Config_Xml('config.xml', 'site', true);
$db = Zend_Db::factory($config->database);
$db->setFetchMode(Zend_Db::FETCH_OBJ);
$db->query($config->database->init);
Zend_Db_Table::setDefaultAdapter($db);

class Users extends Zend_Db_Table
{
  protected $_name = 'users';
  protected $_dependentTables = array('Members');
  protected $_referenceMap = array();
}

class Groups extends Zend_Db_Table
{
  protected $_name = 'groups';
  protected $_dependentTables = array('Members');
  protected $_referenceMap = array();
}

class Members extends Zend_Db_Table
{
  protected $_name = 'members';
  protected $_dependentTables = array();
  protected $_referenceMap = array(
    'Users' => array(
      'columns' => 'user_id',
      'refTableClass' => 'Users',
      'refColumns' => 'user_id'
    ),
    'Groups' => array(
      'columns' => 'group_id',
      'refTableClass' => 'Groups',
      'refColumns' => 'group_id'
    )
  );
}

$is_active_only = true;
$limit = null;
$table = new Users();
$groupTable = new Groups();
$memberTable = new Members();

$select = $table->_db->select()
->from(array('u'=>'users'),array('u.username','u.full_name'))
->joinLeft(array('m'=>'members'),'u.member_id = m.member_id',array('m.title'))
->joinLeft(array('g'=>'groups'),'m.group_id = g.group_id',array('g.group_name'))
->order('u.user_id');

if($is_active_only)
{
  $select->where('u.is_active = ?', 1);
}

if(isset($limit))
{
  $select->limit($limit, 0);
}

$resultArray = $select->query()->fetchAll();

if($row = $table->fetchRow(
  array(
    'username = ?' => $username,
    'is_active = 1'
  )
))
{
  $row->last_login = date('Y-m-d H:i:s');
  $row->save();
  $data = $row->toArray();

  $memberRow = $row->findDependentRowset('Members');
  $data['group_id'] = $memberRow->group_id;
}

$row = $table->createRow($data);
$row->user_id = null;
$row->is_active = 0;
$row->save();