[HELP] sql depends to another sql

[eluser]C_Line[/eluser]
i have a code like this

Code:

controller
function ambil_dataUser($value)
{
$this->load->model("Query_barang",'',TRUE);
$data['query'] = $this->Query_barang->ambil_data_users($value);
$data['id_us'] = $value;
$this->load->view('home_admin');
$this->load->view("liat_transuser",$data);
}

model
function ambil_data_users($id)
{
$query = $this->db->query("select * from transaksi_users where id_users = '$id'")->result();
return $query;
}


view
foreach($query as $hsl){ // <-- this code used to retrieve id and transaction number


$querys = $this->db->query("select t.id_users,t.status_transaksi,t.tanggal_pesan,b.id_barang,b.nama_barang,b.harga,b.berat,s.qty
from transaksi_users t,barang b, shopcart_user s
where t.id_users = '$hsl->id_users' and t.notrans_users = $hsl->notrans_users and s.notrans_users = t.notrans_users and b.id_barang = s.id_barang")->result();

foreach($querys as $row)
{
echo "<tr><tD>$row->nama_barang</td></tr>";
}}

ex: i have 2 transaction like id = 1 and id = 2
on $querys i can't use it in model because it always return the last value
so i put that code in view, please help,, thx