create table if not exists users (id integer primary key,dates, inmoney,outmoney);

INSERT INTO table (dates,nmoney,outmoney) values (2019-01-01, 12, 5);

    $a1=$this->date1->value;
    $a2=$this->date2->value; 
$a=$this->form('balances')->table->selectedItem;
$this->form('balances')->table3->items->clear();
$artar=$this->database->query('SELECT tar from users where tar BETWEEN "'.$a1.'" AND "'.$a2.'" group by tar');
foreach($artar as $vt){
$arrt = ($vt->toArray());
//$rrt[] = $arrt[tar];
$ar=$this->database->query('SELECT  tar, round(sum(deb-kr),2) from users as gat  WHERE gat = "'.$a[an].'" 
and tar BETWEEN "'.$a1.'" AND "'.$arrt[tar].'"  order by "round(sum(deb-kr),2)" ');    
foreach($ar as $v){
$arr[]= ($v->toArray());

                        }
                     } 
$input = array_map("unserialize", array_unique(array_map("serialize", $arr)));
$this->form('balances')->table3->items->addAll($input);