Rolling up multiple rows into a single row and column from two tables Here is my code 

SELECT   
              register cr.id,
              register_cr.first_name,
              register_cr.father_name,
              register_cr.surname,
              register_cr.address,
              cr_record.charge,
              cr_record.date,
              cr_record.charge_type,
              cr_record.fir_no
FROM 
             register_cr as register_cr
INNER JOIN 
             cr_record as cr_record ON register_cr.id = cr_record.cri_reco_id
The GROUP_CONCAT allows this form of transformation:

SELECT   
              register_cr.id,
              register_cr.first_name,
              register_cr.father_name,
              register_cr.surname,
              register_cr.address,
              GROUP_CONCAT(DISTINCT cr_record.charge SEPARATOR "\n"),
              GROUP_CONCAT(DISTINCT cr_record.date SEPARATOR "\n"),
              GROUP_CONCAT(DISTINCT cr_record.charge_type SEPARATOR "\n"),
              GROUP_CONCAT(DISTINCT cr_record.fir_no SEPARATOR "\n")
FROM 
             register_cr as register_cr
INNER JOIN 
             cr_record as cr_record ON register_cr.id = cr_record.cri_reco_id
GROUP BY register_cr.id