SQL JOIN select ids by string array

Question

I have some tables. picture

people_ids type is TEXT. No foreign keys used. main_id - is like main parent, one from PEOPLE table;

picture

I need SQL request to get result. SELECT * from families ...

[
  'main' => [
    'name' => 'John',
    'surname' => 'Brown'
   ],
  'people' => [
     [
      'name' => 'John',
      'surname' => 'Brown'
     ],
     [
      'name' => 'Merry',
      'surname' => 'Brown'
     ],
     [
      'name' => 'Lizy',
      'surname' => 'Brown'
     ]
   ]
]