Join from three tables in sqlite

Hello i need some help with a query.

I got three tables, these i want to join togheter in some way so everything in the database can be show. Of course it dosen´t work to do a natural join with all three tables because of the "children" table and it is gives me many duplicates.

create table member (
   id integer,
   givenName    varchar(50),
   familyName   varchar(50),
   email        varchar(50),
   gender       varchar(6),
   birth        varchar(10),
   memberSince  varchar(10),
   active       int);

create table funktion (
   id integer,
   role integer,
   team varchar(10));

create table children (
   pid integer,
   cid integer);