foreach ($data as $member) {
		    $groupid = $member->date;
		    if (isset($sorted[$groupid])) {
		        $sorted[$groupid][] = $member;
		    }
		    else {
		        $sorted[$groupid] = array($member);
		    }
		}

		// formatting as required by app end
		foreach ($sorted as $key => $value) {
			$x[$key] = new stdClass();
			$x[$key]->day = $value[0]->day;
			$x[$key]->date = $value[0]->date;
			$x[$key]->details = $value;

			foreach ($value as $k => $v) {
				$sub_category_name = explode(",", $value[$k]->sub_category_name);
				$num_of_person = explode(",", $value[$k]->num_of_person);

				$sc = array();
				foreach ($sub_category_name as $k1 => $v1) {
					$sub_category = new stdClass();
					$sub_category->sub_category_name = $sub_category_name[$k1];
					$sub_category->num_of_person = $num_of_person[$k1];
					$sc[] = $sub_category;
				}
				// assigning value to new parameter
				$value[$k]->sub_category = $sc;
				// unset extra parameters
				unset($value[$k]->sub_category_name);
				unset($value[$k]->num_of_person);
				unset($value[$k]->day);
				unset($value[$k]->date);
			}
		}

		foreach ($x as $v) {
			$response[]=$v;
		}