public function get_request($requestid)
{
    $this->db->select('*');
    $this->db->From('instanthire as s');
    $this->db->join('instanthire_skills as ss','s.id = ss.requestid');
    $this->db->where('s.id',$requestid);
    $query = $this->db->get();
    return $query->result_array();
}@H_406_8@ 
 
我得到的结果是
 
 
 
 
Array
(
    [0] => Array
        (
            [id] => 1
            [userid] => 1
            [skills] => htML
        )

    [1] => Array
        (
            [id] => 2
            [userid] => 1
            [skills] => core PHP
        )
)
Array
(
    [0] => Array
        (
            [id] => 3
            [userid] => 2
            [skills] => Core Java
        )

    [1] => Array
        (
            [id] => 4
            [userid] => 2
            [skills] => Advance Java
        )
    [2] => Array
        (
            [id] => 4
            [userid] => 2
            [skills] => .net
        )
)
 
 
问题是,对于每个用户标识,数组的数量随着技能的增加而增加,我希望为每个用户标识创建一个数组,并且该用户的技能应该在主数组中.任何人都可以告诉我如何纠正我的阵列
 
 
表结构
 
 
instanthire
 
 
 
 
id  userid 
1     1
2     2
 
 
instanthire_skills
 
 
 
 
id  requestid  skills
1    1         html
2    1         core PHP
3    2         core java
4    2         advance
5    2         .net
 
 
期望的输出
 
 
 
 
Array
(
    [0] => Array
        (
            [id] => 1
            [userid] => 1
            [skills] => Array
                (
                    [0] => html
                    [1] => core PHP
                )
        )

    [1] => Array
        (
            [id] => 3
            [userid] => 2
            [skills] => Array
                (
                    [0] => core java
                    [1] => advance java
                    [2] => .net
                )
       )
)